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

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.

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

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

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

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