topic Re: Database connection to SQL Server Web Edition in Data Management Questions

Database connection to SQL Server Web Edition

Ignacio_JavierMoratiel_Rodrígu — Mon, 28 Aug 2017 10:59:06 GMT

Is it possible to create a connection to SQL Server Web Edition (v12.0.5000) from ArcCatalog? I've updated SQL Server Native Client to the latest version possible but I get this error when I create the connection: "Connection was attempted with an older version of SQL Server client communications software that is not supported"

From other applications I can connect without problems, it is only ArcCatalog that does not connect

Re: Database connection to SQL Server Web Edition

Asrujit_SenGupta — Mon, 28 Aug 2017 11:16:43 GMT

Microsoft SQL Server database requirements for ArcGIS 10.5.x—System Requirements | ArcGIS Desktop

As per the above documentation, supported SQL Server editions are Express, Standard and Enterprise.

However, which version of ArcGIS Desktop are you working with?
What version of SQL Server Native Client\ODBC Driver have you installed? (Share the link if possible)

Re: Database connection to SQL Server Web Edition

Ignacio_JavierMoratiel_Rodrígu — Mon, 28 Aug 2017 14:15:41 GMT

I'm working with ArcGIS Desktop 10.5, about Native client I installed v2012 (Download Microsoft® SQL Server® 2012 Native Client - QFE from Official Microsoft Download Center )

Thanks for your help Asrujit

Re: Database connection to SQL Server Web Edition

JoshuaBixby — Mon, 28 Aug 2017 15:59:51 GMT

Native Client is on the way out, try Download Microsoft® ODBC Driver 13 for SQL Server® - Windows + Linux from Official Microsoft Download Center .

Re: Database connection to SQL Server Web Edition

Asrujit_SenGupta — Mon, 28 Aug 2017 16:14:30 GMT

As the system requirement page mentions:

Note:
**The Microsoft ODBC Driver 13 for SQL Server is only supported by ArcGIS 10.5.x and 10.4.1 clients. For connections from ArcGIS 10.4 clients, the Microsoft ODBC Driver 11 must be used.

So, try the ODBC Driver 13 (64-Bit) in the link that Joshua provided and let us know if that helps.

Re: Database connection to SQL Server Web Edition

Ignacio_JavierMoratiel_Rodrígu — Tue, 29 Aug 2017 09:42:10 GMT

It has not worked, it still gives the same error. I can generate a temporary user for you to verify yourselves, for now it is impossible to connect to SQL Server

Thanks for your help

Re: Database connection to SQL Server Web Edition

Asrujit_SenGupta — Tue, 29 Aug 2017 10:01:36 GMT

I believe contacting Esri Tech Support for a quick clarification maybe a better option.

Re: Database connection to SQL Server Web Edition

Ignacio_JavierMoratiel_Rodrígu — Wed, 30 Aug 2017 09:06:53 GMT

Ok, I will contact them

Thanks for your help