Adding a database server for the product library (Production Mapping)

This section describes how to add a database server connection under the Database Servers node in the Catalog window. This is a connection to a Microsoft SQL Server Express instance set up to store geodatabases.

Steps:

1. Start ArcMap, open the Catalog window, then expand the Database Servers folder in the Catalog tree.
2. Double-click Add Database Server.
3. In the Add Database Server dialog box, provide the name of the database server.

   This is in the form <server_name>\<instance_name>, where the server name is the name of the server on which SQL Server Express is installed, and the instance name is the name of the SQL Server Express instance.

   An example would be a case where a database server is named SOPHIE\SQLEXPRESS, where SOPHIE is the server name and SQLEXPRESS is the instance name. Using 127.0.0.1 for the server name will avoid sourcing issues if multiple users are going to be accessing the product library.

4. Click OK.

The server icon appears under Database Servers in the Catalog tree.

Tip:

If you add the database server and the icon appears in the Catalog tree with a blank white square on it, the database server has been added but its status is unknown. Try double-clicking it to connect. If you are unable to connect, contact the administrator of that database server to find out if the SQL Server Express instance is running and connected to the network and what type of permission you have on that database server.