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

   Note:

   ST_Raster is not supported in the multiple spatial database geodatabase model in SQL Server. Any database named sde is considered a multiple spatial database. Therefore, ST_Raster is not supported in databases named sde.

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