ArcCatalog 10.8.2

[BrianFoley1]

I just upgraded from ArcCatalog 10.5.1 to 10.8.2.  I am having an issue connecting to a SQL Server database (was having same issue in 10.5.1).  The following message is what I'm getting.

I created a Universal Data Link and can successfully connect to the SQL Server database in question, using the same userid/password that I'm using in ArcCatalog.

Any ideas ?

Brian

[MichaelVolz]

Do you have an appropriate Native SQL Server client installed on this machine as you said you were having this same issue in ArcCatalog 10.5.1?

[BrianFoley1]

I have SQL Server 2012 Native Client installed.  The strange thing is I was able to connect up to a month ago.  Then I couldn't connect.  I verified with our DBA that no changes were made to the database.

[JayantaPoddar]

The minimum version of SQL Server supported by ArcGIS 10.8.2 is Microsoft SQL Server 2016 (64-bit) .

Please upgrade to a supported version of database/client.

Microsoft SQL Server database requirements for ArcGIS 10.8.x and ArcGIS Pro 2.5, 2.6, and 2.7—System...

[MichaelVolz]

Jayanta:

Can you install more than 1 SQL Server Native Client on a machine?

[JayantaPoddar]

I believe, we can.

[MichaelVolz]

How do you know which SQL Server Native Client ArcGIS is using if you have multiple Native Client versions installed on your computer?

I ask because I do not see any reference to a SQL Server Native Client in the Path environmental variable like I would see for an Oracle Client where order in the Path environmental variable is important in determining which Oracle Client is being used?

[Robert_LeClair]

Right click on the ArcCatalog and "Run as Administrator"  Once ArcCatalog has started, attempt to make a database connection to your SQL Server database.  Does it connect?

[BrianFoley1]

I just tried this on a machine I am running ArcCatalog 10.5.1 on.  Same error as in my original post.

[Robert_LeClair]

Hmmm...I wonder if it's a System Requirement issue for SQL Server and ArcGIS.  You mentioned you're using SQL Server 2012 but this is not supported at 10.8.x - latest edition supported is SQL Server 2014 SP 3 (64-bit).  ArcGIS 10.6 supported SQL Server 2012 SP3 (64-bit).  Can you create an ODBD connection in ArcCatalog?