HOW TO

Confirm connectivity to a SQL Server database using ODBC Data Source Administrator

Last Published: September 27, 2024

Summary

This article can be used to confirm ArcGIS Pro and ArcGIS Server machine connectivity to a SQL Server Database using ODBC Data Source Administrator.

Procedure

  1. Start 'C:\Windows\System32\odbcad32.exe' to open the ODBC Data Source Administrator.
  2. On the User DSN tab click Add.

adding a user DSN 

  1. Select ODBC Driver 18 for SQL Server (or another relevant version of ODBC Driver for SQL Server) and click Finish.
  2. Enter a name for the Data Source, the name of the SQL Server instance, and click Next.

entering the name of the Data Source and SQL Server instance 

  1. Configure How should SQL Server verify the authenticity of the login ID, and enter the Login ID and Password as required.

configuring the login

  1. Enable the Change the default database to option, select the relevant database from the drop-down list, and press Next.

changing the default database

  1. Leave the options on the next screen as default and press Finish.
  2. Press Test Data Source on the next screen and check the outcome, as shown in the images below.

test the data source

success message

Article ID: 000033268

Software:
  • ArcGIS Pro
  • ArcGIS Enterprise

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options