ArcGIS supports connections to Microsoft SQL Server databases and enterprise geodatabases in SQL Server.
Tip:
For ArcGIS releases prior to 10.9 and ArcGIS Pro 2.7, see the system requirements on the ArcGIS Desktop website.
Visit Esri Technical Support for information on the Esri Supported Environment Policy.
Supported database versions
The following Microsoft SQL Server releases are the minimum certified versions supported with ArcGIS. SQL Server service packs and cumulative updates on these versions are supported but not certified.
Enterprise/Standard/Developer* editions
Microsoft SQL Server 2019 (64-bit)
Microsoft SQL Server 2019 on Linux (64-bit)
Microsoft SQL Server 2017 (64-bit)
Microsoft SQL Server 2017 on Linux (64-bit)
Microsoft SQL Server 2016 (64-bit)
Express editions
Microsoft SQL Server 2019 (64-bit)
Microsoft SQL Server 2017 (64-bit)
Microsoft SQL Server 2016 (64-bit)
Note:
*Developer edition is only supported in non-production environments.
Supported operating systems
If your database management system is installed on a server where ArcGIS products are installed, the server operating system must meet the ArcGIS product system requirements as well as the operating system requirements for your SQL Server version.
If your database is not installed on the same server as an ArcGIS product, see the Microsoft documentation for operating system requirements for your SQL Server version.
Cloud support
See Requirements for using ArcGIS with databases in the cloud for information on support for database services and databases deployed in the cloud.
Software required to connect to SQL Server
Any client machines that connect directly to SQL Server must have a SQL Server client installed. SQL Server clients for Microsoft Windows and Linux are distributed by Microsoft. SQL Server clients for Windows are also available on My Esri. You must install a client that is the same version or a newer version than the SQL Server database to which you want to connect. If you upgrade SQL Server, upgrade the SQL Server clients at the same time. When a version of SQL Server is no longer supported by ArcGIS, the corresponding SQL Server client library will no longer be supported either.
Supported SQL Server clients are as follows:
- SQL Server 2019
- Microsoft ODBC Driver 17 for SQL Server
- SQL Server 2017
- Microsoft ODBC Driver 17 for SQL Server
- SQL Server 2016
- Microsoft ODBC Driver 17 for SQL Server
- Microsoft ODBC Driver 13 or 13.1 for SQL Server
Note:
When connecting from ArcGIS Server on Ubuntu to a supported version of SQL Server, you must install the Microsoft unixodbc-dev package on all ArcGIS Server machines in addition to the ODBC driver.
When connecting from ArcGIS Server on Ubuntu to SQL Server 2016, you must configure the SQL Server instance with SHA-256. This is described in the Microsoft Blog, SHA-256 Self Signed Certificate for Windows Server 2012 R2 and Microsoft help article Enable encrypted connections to the Database Engine.