topic Re: Where are the Linux Native Clients for MS SQL 2012? in ArcGIS Enterprise Questions

Where are the Linux Native Clients for MS SQL 2012?

MarkLittell — Thu, 23 Jun 2016 21:12:16 GMT

I have an ESRI ArcGIS 10.3.1 Linux server.

I am trying to register a MS SQL 2012 Database to it - it fails with:

Machine: <snip>[<snip>: The connection property set was missing a required property or the property value was unrecognized. Underlying DBMS error [Unknown errorNo extended error.]]

Looking into this, it appears I need the MS SQL Native Client for the ArcGIS server - I can find it for an installation on a Windows OS.

Where can I find the Linux Native Clients for MS SQL 2012?

Please don't say - my.esri.com - I have scoured over that site and still come up empty.

Thanks for your help.

- Mark

Re: Where are the Linux Native Clients for MS SQL 2012?

JonathanQuinn — Fri, 24 Jun 2016 17:00:30 GMT

I've never come across the MS SQL Native Client for Linux. It looks like there's a ODBC driver for MS SQL on Linux:
Introducing the new Microsoft ODBC Drivers for SQL Server | Microsoft SQLNCli team blog

I don't think that'll take the place of the Native Client required for ArcGIS Server, though...

Re: Where are the Linux Native Clients for MS SQL 2012?

George_Thompson — Fri, 24 Jun 2016 17:45:47 GMT

You cannot connect from ArcGIS for Server Linux to SQL Server per the documentation,

You cannot connect to SQL Server from ArcGIS for Server on Linux.

ArcGIS 10.4.x for Server system requirements—Installation Guides (10.4.1) | ArcGIS for Server

Re: Where are the Linux Native Clients for MS SQL 2012?

MarkChilcott — Wed, 18 Aug 2021 01:18:00 GMT

It's an old thread - but for completeness the ArcGIS now supports connecting to Microsoft SQL Server databases on Linux. You can also create geodatabases in SQL Server on Linux. In addition, you can connect from ArcGIS Server on Linux to SQL Server on Windows or Linux. Introduced in 10.6

What's new in ArcGIS Server 10.6