1. Úvod
Připojení k Microsoft SQL Server z ArcGIS | Dokumentace ArcGIS Pro
Připojení k Microsoft SQL Server z ArcGIS | Dokumentace ArcGIS Server
Připojení k Microsoft SQL Server z ArcGIS | Dokumentace ArcMap
2. Požadavky ArcGIS na SQL Server
Požadavky ArcGIS na SQL Server
Tip:Pro verze ArcGIS před 10.9 aArcGIS Pro2.8, vizsystémové požadavky nawebu ArcGIS Desktop.
Všechny klientské počítače, které se připojují přímo kSQL Servermusí mít nainstalovaného klientaSQL Server.SQL Serverklienti proMicrosoft WindowsaLinuxjsou distribuováni společnostíMicrosoft.SQL Serverklienti proWindowsjsou také dostupní na stránce . Musíte nainstalovat klienta, který je stejné nebo novější verze než databáze
SQL Server clients are as follows:
SQL Server 2019
- Microsoft ODBC Driver 18 for SQL Server**
- Microsoft ODBC Driver 17 for SQL Server
SQL Server 2017
- Microsoft ODBC Driver 18 for SQL Server**
- Microsoft ODBC Driver 17 for SQL Server
SQL Server 2016
- Microsoft ODBC Driver 18 for SQL Server**
- Microsoft ODBC Driver 17 for SQL Server
- Microsoft ODBC Driver 13 or 13.1 for SQL Server
** 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.
3. Microsoft ODBC Driver for SQL Server on Windows
Microsoft ODBC Driver for SQL Server on Windows - ODBC Driver for SQL Server | Microsoft Learn
Download ODBC driver
4. Install the ODBC driver for SQL Server
Connect to Microsoft SQL Server from ArcGIS
Obtain the 64-bit Microsoft ODBC driver for SQL Server from the Microsoft Download Center or from My Esri. Be sure to get the Microsoft ODBC driver that is supported for the version of SQL Server to which you want to connect. Install the driver on all computers where ArcGIS Pro and ArcGIS Server are installed.
If you do not have the privileges to install software on the machines where ArcGIS clients are running, you'll need to have your IT department install and configure the Microsoft ODBC driver for you.
If you are installing the driver on a 64-bit operating system, run the 64-bit executable; it installs both 32- and 64-bit files. If you run the 32-bit installation on a 64-bit operating system, it will fail.
Note:
If ArcGIS Server and SQL Server are installed on the same server, a separate ODBC driver is not required on that machine.
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.
5. Bug: Database connections to SQL Server fail when Microsoft ODBC Driver 18 is installed
Early versions of ArcGIS Pro fail to connect with the Microsoft ODBC Driver 18.
Bug: Database connections to SQL Server fail when Microsoft ODBC Driver 18 is installed (esri.com)
6. System Requirements
ArcGIS requirements for SQL Server
Tip: For ArcGIS releases prior to 10.9 and ArcGIS Pro 2.8, see the system requirements on the ArcGIS Desktop website.
7. Microsoft ODBC Driver 18 for SQL Server
- if you have ArcGIS Desktop 10.8.2 and ArcGIS Pro 3.1 installed on the same machine,
- and you want to connect to SQL Server Geodatabases then
- make sure you have only the Microsoft ODBC Driver Version 17 installed.
- ArcGIS Pro 3.1 works with Microsoft ODBC Driver Version 18 and 17.
- but ArcGIS Desktop 10.8.2 works only with Microsoft ODBC Driver Version 17.
