Installing the ST_Raster type in a remote SQL Server database

If the ArcSDE command line tools and SQL Server are installed on different servers, follow these instructions to create the ST_Raster assembly and configure access to it:

Steps:

1. Install the ArcSDE application server for SQL Server and command line tools.

   This installation can be downloaded from the Esri Customer Care Portal.

2. Log in to the SQL Server remote host machine.
3. Create a folder on the SQL Server server to hold the ST_Raster library.

   Be sure SQL Server has access to the folder.

4. Add the absolute path of the folder to the system path.
5. Copy the libst_raster_sql.dll file from the ArcSDE command line installation bin directory on the ArcSDE server and paste it into the SQL Server folder you created in step 3.
6. Copy the createAssembly.sql file from the tools directory of %SDEHOME% on the ArcSDE server and paste it into the folder you created in step 3.
7. From an MS-DOS prompt, navigate to the location of the createAssembly.sql file you copied in the previous step and run sqlcmd to execute it.

   The assembly must be created by a sysadmin user.

   The following is the syntax to execute the script:

   sqlcmd -E -S <SQL Server instance> -d  <database name> 
   -v st_raster_path="<full path to folder created in step 3>\libst_raster_sql.dll" 
   -v  admindb=<database name> -i createAssembly.sql
   

   For example:

   sqlcmd -E -S instance1 -d  ssgdb 
   -v st_raster_path="c:\mygdblibraries\libst_raster_sql.dll" 
   -v  admindb=ssgdb -i createAssembly.sql
   

   See Microsoft Books Online for SQL Server to learn about the sqlcmd utility and its uses.

8. Log in to the server where the ArcSDE command line tools are installed.
9. Run the sdesetup command with the install_st_raster operation.

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

10. Using SQL Server Management Studio, connect as any user that has access to the database where you installed ST_Raster, and test the installation of the ST_Raster type by executing the following SELECT statement against that database:

    SELECT <dbo or sde>.st_raster_util_getVersion();
    

    The query should return at least 1,000.

11. 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 ssgdb -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 ssgdb -u sde
      
       sdedbtune -o insert -k ST_RASTER -P UI_TEXT -v UI_TEXT 
      -i sde:sqlserver:serverb\ssdb -D ssgdb -u sde