---
title: "ODBC Connect ArcGIS to Maxwell Data Schema(MDS)"
canonical: "https://servicedesk.maxgeo.com/space/MDS/1467678722/ODBC%20Connect%20ArcGIS%20to%20Maxwell%20Data%20Schema(MDS)"
format: markdown
---
**Connect ArcGIS Pro to MDS**

DataShed5

Connect ArcGIS Pro to the Maxwell Data Schema(MDS) using an ODBC connection.


**Configure instance to allow remote connections**

The SQL instance is by default configured not to allow remote connections.

This needs to be changed by someone with administrator privileges.


**Install an ODBC driver**

Download a 64bit ODBC driver for SQL Server from Microsoft.

To decide on the best ODBC driver for your version of SQL Server, see the knowledge base article called **ODBC Driver Compatibility** in maxgeo’s service desk portal

[https://servicedesk.maxgeo.com/space/DataShed4/1389854722/ODBC+Driver+Compatibility](https://servicedesk.maxgeo.com/space/DataShed4/1389854722/ODBC+Driver+Compatibility) 


**Open the Database Connection window**

1. Open the Catalog pane in ArcGIS Pro
2. Right-click Databases > New Database Connection

![image](media://c8ae44db-f9dc-4855-8747-398bf6e7305c)

**Configure the connection**

1. Choose SQL Server in Database Platform
2. Supply and Instance Name

- Named / default instances
- Include port number if not default 1433
- Amazon RDS: <database_instance_identifier>.<region_id>.rds.amazonaws.com
- Google Cloud: use the public IP address
- Azure: provide the server name in the Instance box

Choose Authentication Type

- Operating system
- Database
- Microsoft Entra
  - MFA (provide Entra ID username)
  - Password (provide username and password)
  - Integrated (uses login name and password)

1. Choose the Database name (limit 31 characters)
2. Connection File name

- This is the name that will appear in Catalog
- Also used for the file name of the .sde file

Additional Properties

- Port (if not default)
- Encrypt (SSL encryption)
- TrustServerCertificate (encryption without client certificate)
- Application Intent (ReadOnly or ReadWrite)
- MultisubnetFailover

Click the Validate button to test the connection


**ArcGIS Server web service**

To publish ArcGIS Server web services that reference the data in the SQL Server database, register the database connection file with your ArcGIS Server sites

Full ESRI article: 

[https://pro.arcgis.com/en/pro-app/latest/help/data/databases/connect-sqlserver.htm](https://pro.arcgis.com/en/pro-app/latest/help/data/databases/connect-sqlserver.htm)