A geodatabase can be created in SQL Server and configured to operate as a Nautical Information System (NIS) workspace that can be used in an enterprise environment.
Creating an enterprise geodatabase
The server administrator needs to create a new geodatabase in SQL Server that can be used as the NIS workspace.
For more information, see Geodatabases in Microsoft SQL Server.
Recommendations for geodatabases in SQL Server
It is recommended that the following parameter values are used when creating a 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 |