topic Re: ArcGIS Pro SQL Server Failed to Connect to Specified DBMS Instance Error in ArcGIS Pro Questions

ArcGIS Pro SQL Server Failed to Connect to Specified DBMS Instance Error

DanielKepner_Garcia — Wed, 17 Apr 2019 19:51:48 GMT

When using ArcGis Pro, I keep getting an error when trying to connect to SQL Server databases. The error isn't very specific on what the issue is. "Failed to connect to specified DBMS instance." and "An unexpected fatal exception has occurred within this application. Execution should be terminated."

I attached a picture of the message I get.

The strange thing is when I use ArcMap I am perfectly able to connect.

Any thoughts on what the issue might be?

ArcGis Pro 2.2.0 (64-bit)

ArcMap 10.5.1 (32-bit)

Re: ArcGIS Pro SQL Server Failed to Connect to Specified DBMS Instance Error

MichaelVolz — Wed, 17 Apr 2019 22:54:42 GMT

Are you trying to use the same SQL Server client to connect to both geodatabases? You need a 32 bit client to connect to ArcMap and a 64 bit client to connect to Pro. The order of the database client in the path environmental variable may be important and I would put the 64 bit client first to start. You will need admin privileges on the computer to make these changes.

Re: ArcGIS Pro SQL Server Failed to Connect to Specified DBMS Instance Error

Asrujit_SenGupta — Wed, 14 Jun 2023 10:02:25 GMT

Michael Volz wrote:

Are you trying to use the same SQL Server client to connect to both geodatabases? You need a 32 bit client to connect to ArcMap and a 64 bit client to connect to Pro. The order of the database client in the path environmental variable may be important and I would put the 64 bit client first to start. You will need admin privileges on the computer to make these changes.

No. The client bit level matters in case of Oracle only.

For SQL Server, the Native Client bit level depends on the OS Bit level. So, if you have a 64-Bit OS, install 64-Bit Native Client (ODBC Driver) and that will allow you to connect with both ArcGIS Pro and ArcGIS Desktop.

Re: ArcGIS Pro SQL Server Failed to Connect to Specified DBMS Instance Error

Asrujit_SenGupta — Thu, 18 Apr 2019 04:05:59 GMT

ArcGIS Pro and ArcGIS Desktop are on the same server?

What is the version of SQL Server being used?

Re: ArcGIS Pro SQL Server Failed to Connect to Specified DBMS Instance Error

DanielKepner_Garcia — Thu, 18 Apr 2019 15:50:11 GMT

I'll download the 64bit SQL Server ODBC driver and see if that fixes the issue. Thanks for the tip.

Re: ArcGIS Pro SQL Server Failed to Connect to Specified DBMS Instance Error

DanielKepner_Garcia — Thu, 18 Apr 2019 16:03:29 GMT

Yes, ArcGIS Pro and ArcMap are on the same local machine. I am trying to connect to a SQL Server 2016 server

Re: ArcGIS Pro SQL Server Failed to Connect to Specified DBMS Instance Error

DanielKepner_Garcia — Thu, 18 Apr 2019 17:25:30 GMT

I have both SQL Server and SQL Server Compact Edition installed on my machine now and SQL Server is in my path. I am still getting the error.

Re: ArcGIS Pro SQL Server Failed to Connect to Specified DBMS Instance Error

JYI — Wed, 22 Jan 2020 22:04:07 GMT

Has anybody have solution to this question? I have the same issue recently about a week ago, with this Azure SQL database (version Microsoft SQL Azure (RTM) - 12.0.2000.8). Before it worked fine in ArcGIS Pro 2.4. I totally removed ArcGIS Pro and reinstalled it, no any luck.

I am still able to use ArcMap 10.6.1 to connect to the same database on the same machine, and I can still use Microsoft SQL Server Management Studio 18 to connect to the same database on the same machine too.

Why does only ArcGIS Pro have this issue?

Any possible solutions?

Thanks.

Re: ArcGIS Pro SQL Server Failed to Connect to Specified DBMS Instance Error

ThomasColson — Thu, 23 Jan 2020 12:01:32 GMT

Since you can install the SQL tools, can you run a SQL trace while you're trying to connect to SQL from Pro? I have kept many cases away from busy tech support by looking at the traces generated by SQL profiler, to realize the problem was on my end (e.g insufficient permissions, etc...)