ArcGIS supports connections to Microsoft SQL Server databases and enterprise geodatabases in SQL Server.
SQL Server databases used to store a geodatabase must be configured with a collation that is not case sensitive.
Tip:
For ArcGIS releases prior to 10.9, 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*, and Express editions
Microsoft SQL Server 2022 (64 bit)
Microsoft SQL Server 2022 on Linux (64 bit)
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)
Note:
*Developer edition is only supported in nonproduction 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 minimum SQL Server clients¹ are as follows:
- SQL Server 2022
- Microsoft ODBC Driver 18.1 for SQL Server²
- SQL Server 2019
- Microsoft ODBC Driver 18 for SQL Server²
- Microsoft ODBC Driver 17.3 for SQL Server
- SQL Server 2017
- Microsoft ODBC Driver 18 for SQL Server²
- Microsoft ODBC Driver 17 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.
² Microsoft changed the default encryption setting for the ODBC driver to yes with the release of ODBC Driver 18. To ensure existing database connections continue to work even if you update to ODBC Driver 18, encryption is set to no by default. To use an encrypted connection instead, you can configure the database connection as described in Encrypted connections to SQL Server databases.