This workflow guides you on how to create and configure a BIS workspace in a geodatabase in SQL Server.
Creating an enterprise geodatabase
The server administrator needs to create a new geodatabase in SQL Server that can be used as the BIS workspace.
Recommendations for geodatabases in SQL Server
It is recommended that the following parameter values are 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 |