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 * 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

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ArcGIS Pro 2.0.1- SQL Server Database 2016 connection error

Roxana_ElenaUrdea

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

Find more posts tagged with

Accepted answers

All comments

MikeVolz

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.

Roxana_ElenaUrdea

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

Asrujit_SenGupta

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....

KrishnaRohitYejju

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.

Roxana_ElenaUrdea

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!

Asrujit_SenGupta

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

RickGeittmann

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

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.