ArcGIS for Desktop

  • Documentation
  • Pricing
  • Support

  • My Profile
  • Help
  • Sign Out
ArcGIS for Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS for Desktop

A complete professional GIS

ArcGIS for Server

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Pricing
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

Connect to a desktop or workgroup geodatabase

Most people need to access and work with datasets in geodatabases, but not to perform administration tasks. If you are connecting to a desktop or workgroup geodatabase to create or work with the data in the geodatabase, you can connect using the Database Connection dialog box.

You need the following information to use the Database Connection dialog box:

  • The name of the SQL Server Express instance used for the database server
  • The name of the database that contains the desktop or workgroup geodatabase

Follow these steps to connect to a desktop or workgroup geodatabase from the Database Connections node in ArcGIS for Desktop:

  1. Expand the Database Connections node in the Catalog window in ArcMap.
  2. Double-click Add Database Connection.

    The Database Connection dialog box opens.

  3. Choose SQL Server from the Database Platform drop-down list.
  4. 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, provide the instance name in this format: <computername>\<instance>; for example, yourcomputer\sqlex1.

  5. Choose Operating system authentication from the Type drop-down list.
  6. Choose or type the name of the geodatabase to connect to in the Database text box.
  7. Click OK to make the connection.

A new connection file is created under the Database Connections node in the Catalog tree.

Tip:

You can reopen the Database Connection dialog box to change the connection information by right-clicking the connection file and clicking Connection Properties.

Related Topics

  • What is the Catalog window?
  • Connecting to a file or personal geodatabase
  • Connecting to an enterprise geodatabase or database from the Catalog tree
  • Adding OLE DB connections to databases
Feedback on this topic?

ArcGIS for Desktop

  • Home
  • Documentation
  • Pricing
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS for Desktop
  • ArcGIS for Server
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Insiders Blog
  • User Conference
  • Developer Summit
Esri
© Copyright 2016 Environmental Systems Research Institute, Inc. | Privacy | Legal