topic Re: ArcGIS Pro 2.0.1- SQL Server Database 2016 connection error in ArcGIS Pro Questions

ArcGIS Pro 2.0.1- SQL Server Database 2016 connection error

Roxana_ElenaUrdea — Wed, 17 Jan 2018 17:06:58 GMT

arcgispro 2.0 sql servers

Hi everyone,

I'm trying to connect to a SQL Server 2016 from ArcGIS PRO 2.0.1 and I'm fancing this ERROR: Failed to connect to the specified DBMS instance. After fill in all the parameters I am able to see the database list but when I click OK it turnes into this message:

Specifications:

Microsoft SQL Server 2016 (SP1) - 13.0.4001.0 (X64) Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows Server 2016 Standard 6.3 <X64>
ArcGIS Pro 2.0.1 running on a Windows Server 2012 R2 Standard

Note:

SQL Server is installed on a different machine

Can anyone help me with this issue?

Thank you

Roxana

Re: ArcGIS Pro 2.0.1- SQL Server Database 2016 connection error

MichaelVolz — Wed, 17 Jan 2018 17:09:30 GMT

You might need to install a SQL Server native client in order to make the connection. This is just a theory, but it's something you can test.

Re: ArcGIS Pro 2.0.1- SQL Server Database 2016 connection error

Roxana_ElenaUrdea — Wed, 17 Jan 2018 17:21:29 GMT

I already have installed Microsoft SQL Server Native Client 2012 and ODBC Driver 13 for SQL Server. Still not working.

Re: ArcGIS Pro 2.0.1- SQL Server Database 2016 connection error

Asrujit_SenGupta — Thu, 18 Jan 2018 04:10:20 GMT

A new update for ArcGIS Pro is out. ArcGIS Pro 2.1. They updated the WebHelp pages with ArcGIS Pro 2.1 requirements, so somehow I am unable to check the previous Pro 2.0.1 requirements:

Microsoft SQL Server database requirements for ArcGIS Pro 2.1—Help | ArcGIS Desktop

Can you update and check....

Re: ArcGIS Pro 2.0.1- SQL Server Database 2016 connection error

KrishnaRohitYejju — Thu, 18 Jan 2018 15:08:27 GMT

Hi Roxana,

Could you verify if your database or SQL Server Instance created with 'case-sensitive' collation. By right click on the instance or the database > Select Properties > Under General page > Verify Maintenance.

Re: ArcGIS Pro 2.0.1- SQL Server Database 2016 connection error

Roxana_ElenaUrdea — Thu, 18 Jan 2018 15:52:06 GMT

Hi Asrujit,

the new release of 2.1 resolved my problem.

I still have a doubt that the DEV version of the SQL Server wasn't recognized bur ArcGIS Pro.

Thank you!

Re: ArcGIS Pro 2.0.1- SQL Server Database 2016 connection error

Asrujit_SenGupta — Thu, 18 Jan 2018 17:48:20 GMT

That shouldn't happen as the official Esri WebHelp suggests that Developer Edition is supported (though not as a Production Environment).

Microsoft SQL Server database requirements for ArcGIS Pro 2.1—Help | ArcGIS Desktop

Supported database versions
Enterprise/Standard/Developer* editions

Re: ArcGIS Pro 2.0.1- SQL Server Database 2016 connection error

RickGeittmann — Fri, 20 Apr 2018 00:23:25 GMT

You may need to add the dynamic port number to your connection string if you are connecting to a Named Instance

[server name]\[named instance],port number

Use a comma after the string and before the port number with no spaces