Installing the ST_Raster type in a local SQL Server database

If ArcSDE is installed on the same server as the SQL Server database, follow these instructions to create the ST_Raster assembly and configure access to it:

Steps:

1. Install ArcSDE for SQL Server.
2. Run the sdesetup command with the install_st_raster operation.

   sdesetup -o install_st_raster -d SQLSERVER
   -D ssgdb -s instance1

3. Using SQL Server Management Studio, connect as any user that has been created to access ArcSDE data, and test the installation of the ST_Raster type by executing the following SELECT statement:

   SELECT <dbo or sde>.st_raster_util_getVersion();

   The query should return at least 1000.

4. Either create an ST_RASTER configuration keyword in the SDE_dbtune table with a RASTER_STORAGE parameter set to ST_RASTER or set the RASTER_STORAGE parameter under the DEFAULTS keyword to ST_RASTER.
   • If you want most or all of your raster data to be created using the ST_Raster type with ArcGIS software, set the RASTER_STORAGE parameter value under the DEFAULTS keyword to ST_RASTER.

     sdedbtune -o alter -k DEFAULTS -P RASTER_STORAGE
     -v ST_RASTER -i sde:sqlserver:serverb\ssdb -D gisdb -u sde

   • If you only want to create some raster data with ST_Raster storage, add a keyword, ST_RASTER, to your SDE_dbtune table and include the RASTER_STORAGE parameter set to ST_RASTER and the UI_TEXT parameter.

     sdedbtune -o insert -k ST_RASTER -P RASTER_STORAGE 
     -v ST_RASTER -i sde:sqlserver:serverb\ssdb -D gisdb -u sde
     
      sdedbtune -o insert -k ST_RASTER -P UI_TEXT -v UI_TEXT 
     -i sde:sqlserver:serverb\ssdb -D gisdb -u sde