Enabling SQL Enterprise for storing data (Maritime Charting)

The Use SQL Enterprise check box in the Solution Properties dialog box allows administrators to store the production databases in an enterprise geodatabase in SQL Server. When you store the production databases in SQL Server Express, the production databases (MDF files) are stored in the product library. However, when you enable data storage in an enterprise geodatabase in SQL Server, the production databases are stored in the server and a connection file is established to allow the products to be checked out and in through the product library. By default, the connection files are stored in the location where you specify your checkout of the product.

Using an enterprise geodatabase in SQL Server gives a hydrographic agency the ability to store all of their products on a server outside of the product library environment. This approach in hydrographic product storage management provides faster check in and checkout times and reduces the amount of data stored in the product library.

If you don't have administrator permissions for the product library, you won't see the Use SQL Enterprise check box.

Note:

Before enabling SQL Enterprise for storing production databases, a SQL Server instance should be created. This should be a named instance rather than the default instance. A database-authenticated administration user (for example, sa) must be created. Windows-authenticated logins must be created for each user that will be creating or working with enterprise nautical products.

Steps:

1. Start ArcMap.
2. If necessary, open the Product Library window by clicking Customize > Production > Product Library on the main menu.

   A tree view of the product library appears.
3. Right-click an existing solution from the Product Library tree view and click Properties.

   The Solution Properties dialog box appears.

4. Click the Nautical SQL Enterprise pane.
5. Check the Use SQL Enterprise check box.

   The connection properties to enable SQL Enterprise are activated.

6. Type the name of the SQL Enterprise server in the Server Name text box.
7. Type the name of the SQL Enterprise service that is running on the SQL server in the Instance Name text box.
8. Type the user name login you use to connect to the service on the SQL Enterprise server in the Admin User Name text box.
9. Type the password you use to connect to the service in the Password text box.
10. Click the ellipsis (...) next to SDE License File and browse to the location of the license file.
11. Type the name of the folder in the SQL Enterprise server for which the SQL service has write permission in the Local Server Folder text box.
    Tip:

    It is recommended that you do not use a network path (UNC notation) to specify the local server folder. For better performance, the local server folder is expected to reside on the server hosting your SQL service.

    Production databases will be created in the folder location by copying and renaming a template database, speeding up the product creation process.

12. Click OK.

You can now store your production databases in an enterprise geodatabase.

Tip:

An SDE connection file is created during checkout of a product and stored on the local operating system.