Installing the ST_Raster type in a remote SQL Server database

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

Steps:

1. Log in to the SQL Server remote host machine.
2. If SQL Server is installed on a Windows operating system (OS) that is different from the OS of your ArcSDE server, (for example, the ArcSDE server is installed on Windows 32-bit, and SQL Server is installed on Windows 64-bit), Install ArcSDE for SQL Server on the SQL Server server to obtain the st_raster, sde, geometry, projection engine, and tiff libraries.
3. Create a folder on the SQL Server server to hold the libraries.

   Be sure the SQL Server database has access to the folder.

4. Add the absolute path of the folder to the system path.
5. Copy libst_raster_sql.dll, sde.dll, sg.dll, pe.dll, and libtiff.dll to the SQL Server folder you created in step 3.
6. Use the createAssembly.sql file located under %SDEHOME%\tools\sqlserver to create the assembly for the ST_Raster library in the SQL Server database.

   The assembly must be created by a sysadmin user.

   The following is an example of a SQL command to execute the script:

   sqlcmd -U sa -P <sa_pwd> -S <ss_server_name> 
   -d  <ArcSDE_admin_DB_name> -v st_raster_path="<full_lib_path>\libst_raster_sql.dll" 
   -v  admindb='<ArcSDE_admin_DB_name> ' -i createAssembly.sql 

7. If you had to install ArcSDE for SQL Server on the SQL Server machine, uninstall it.
8. Log in to the ArcSDE server.
9. 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.

10. 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.

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 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