Connecting to a geodatabase in SQL Server Express
Most users need to access and work with datasets in geodatabases, but not to perform administration tasks. If you are connecting to an ArcSDE geodatabase in SQL Server Express licensed through ArcGIS for Desktop, ArcGIS Engine, or ArcGIS for Server Workgroup to create or work with the data in the geodatabase, create a connection file using the Database Connection dialog box, which can be accessed from the Database Connections node in the Catalog window.
You need the following information to connect using the Database Connection dialog box:
- The name of the SQL Server Express instance
- The name of the database
Follow these steps to create a user connection to a geodatabase in SQL Server Express:
- Expand the Database Connections node in the Catalog window in ArcMap.
- Double-click Add Database Connection.
The Database Connection dialog box opens.
- Choose SQL Server from the Database Platform drop-down list.
Type the name of the SQL Server Express instance in the Instance text box.
SQL Server Express instances used for database servers are always named instances. Therefore, you will provide the instance name in this format: <computername>\<instance>; for example, yourcomputer\sqlex1.
- Type the name of the geodatabase to connect to in the Database text box.
- Choose Operating system authentication from the Type drop-down list.
- Click OK to make the connection.
A new connection file is created under the Database Connections node in the Catalog tree.
You can reopen the Database Connection dialog box to change the connection information by right-clicking the connection file and clicking Connection Properties.