topic Re: Failed to connect to new VM & SQL 2019 database in ArcGIS Enterprise Questions

Failed to connect to new VM & SQL 2019 database

neomapper — Thu, 10 Aug 2023 19:48:34 GMT

We built a new 2016 windows server virtual machine and installed SQL 2019 database but no matter what we do we can't seem to connect to it at all! We tried installing multiple ODBC drivers (versions 17 / 18) but we can't figure out why we can't connect in ArcGIS Pro. Help please!

Re: Failed to connect to new VM & SQL 2019 database

ChadKopplin — Thu, 10 Aug 2023 20:39:43 GMT

Do you have the following file installed as well?

windowsdesktop-runtime-6.0.6-win-x64

Re: Failed to connect to new VM & SQL 2019 database

ChadKopplin — Thu, 10 Aug 2023 20:40:59 GMT

Also, would you mind uploading a screenshot of the specific error as well? Thank you.

Re: Failed to connect to new VM & SQL 2019 database

MarceloMarques — Thu, 10 Aug 2023 20:46:29 GMT

Read my blog article.
How to Install the SQL Server Client for ArcGIS?

Also make sure your SQL Server Instance is configured to accept remote connections.
Configure remote access (server configuration option) - SQL Server | Microsoft Learn