Creating and configuring the Workflow Manager workspace in SQL Server
Creating an enterprise geodatabase
The server administrator needs to create a new enterprise geodatabase in SQL Server that can be used as the Workflow Manager workspace.
For more information on setting up a geodatabase in SQL Server, see A quick tour of setting up a geodatabase in SQL Server.
Recommendations for geodatabases in SQL Server
It is recommended that the following parameter values be used when creating an enterprise geodatabase in SQL Server.
Parameter name | Value |
|---|---|
Server Memory: Use AWE to allocate memory | Enabled |
Processors: Boost SQL Server Priority | Enabled |
Security SQL Server and Windows Authentication mode | Enabled |
Connections: Maximum number of concurrent connections | 0 = unlimited |
Connections: Allow remote connections to this server | Enabled |
Configuring the geodatabase in ArcSDE
The DBMS used for the geodatabase should be configured before the Workflow Manager workspace is set up with the default geometry storage. For more information, see Geodatabase storage in relational databases or The SERVER_CONFIG system table.
All default serverconfig settings should be used, except TCPKEEPALIVE; make sure the TCPKEEPALIVE value is set to 1. This command should be used from the command prompt of a machine where the ArcSDE application server is installed.
Note:Copying and pasting the example may cause syntax errors.
sdeconfig -o alter -v TCPKEEPALIVE=TRUE -i <service> -u sde -p <sde_password>
For more information, see the ArcSDE Administration Command Reference, which is included with the ArcSDE application server installation.