Install the Microsoft ODBC driver for SQL Server on the ArcMap machine, start ArcMap, add the database server to the Catalog tree, and connect to the database server.
Note:
Use ArcMap 10.8.1 or earlier to administer workgroup database servers and the geodatabases stored on them.
Install the ODBC driver
When you connect to a database server (SQL Server Express instance) from an ArcGIS client, you use the SQL Server connection mechanism. Therefore, you must install that mechanism: Microsoft ODBC driver for SQL Server.
You can obtain and install the ODBC driver from the Microsoft Download Center or My Esri. Check the ArcGIS system requirements for SQL Server to confirm which version of the driver ODBC driver is supported for the SQL Server Express and ArcGIS software release you use. Install the driver on all computers from which you will connect to the database server from ArcMap.
To install the driver on a 64-bit operating system, run the 64-bit executable; it installs both 32- and 64-bit files. If you run the 32-bit driver installation on a 64-bit operating system, it will fail.
Add a database server
Add a database server connection in the Catalog tree in ArcMap if you need to perform administrative tasks on a Microsoft SQL Server Express instance or the geodatabases it contains.
Adding a database server creates a database server connection file (a .gds file) in your user folder and an icon in the Database Servers folder for that connection.
To add a database server, you must have permission to access the database server.
Just as with connections to any data source, connections to database servers must be created for each client who needs to manage database servers and their geodatabases.
When you first add a database server connection in the Catalog tree, you are automatically connected to the database server. If you leave the connection open when you close the Catalog window, you are automatically connected when you reopen it.
- Start ArcMap, open the Catalog window, and expand the Database Servers folder in the Catalog tree.
- Double-click Add Database Server.
- On 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.
For example, if a database server is named SOPHIE\SQLEXPRESS, SOPHIE is the server name and SQLEXPRESS is the instance name.
If you are unsure of the name to use, contact the administrator of the database server for this information.
- 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.
Connect to the database server
If you disconnect from the database server, you can double-click the database server in the Catalog tree to connect to it.
Next step
Add logins to the database server.