Skip To Content

Microsoft SQL Server database requirements for ArcGIS 10.9 and ArcGIS Pro 2.8

Visit Esri Technical Support for information on the Esri Supported Environment Policy.

ArcGIS supports connections to Microsoft SQL Server databases and enterprise geodatabases in SQL Server.

Tip:

For earlier ArcGIS versions, see the system requirements on the ArcGIS Desktop website.

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.