topic Re: Connecting to SQL Server 2012 from ArcGIS Pro in ArcGIS Pro Questions

Connecting to SQL Server 2012 from ArcGIS Pro

SamMontoia1 — Wed, 16 Nov 2016 19:25:27 GMT

I am attempting to Connect to an instance of an enterprise database (SQL Server database), but I get the above error message in Pro, but the same connection works just fine in Desktop or Catalog.

I am using Operating system Authentication. 64-bit server, SQL Server 2012

Microsoft SQL Server Management Studio 11.0.2100.60
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 9.11.9600.17633
Microsoft .NET Framework 4.0.30319.42000
Operating System 6.1.7601

Re: Connecting to SQL Server 2012 from ArcGIS Pro

JeffWard — Tue, 06 Jun 2023 17:47:27 GMT

I'm running into this issue. Was there a solution? Is it not possible to connect to a SQL Server 2012 SDE database?

Re: Connecting to SQL Server 2012 from ArcGIS Pro

George_Thompson — Tue, 06 Jun 2023 17:52:07 GMT

What version of Pro are you using @JeffWard ?

Re: Connecting to SQL Server 2012 from ArcGIS Pro

JeffWard — Tue, 06 Jun 2023 17:53:53 GMT

3.1.2

Re: Connecting to SQL Server 2012 from ArcGIS Pro

George_Thompson — Tue, 06 Jun 2023 18:54:38 GMT

Yeah, I would say that SQL 2012 is not supported on that version of Pro; https://enterprise.arcgis.com/en/system-requirements/latest/windows/database-requirements-sqlserver.htm

The "oldest" version of SQL Server supported is 2016. Even Pro 2.8.x does not support SQL 2012.

SQL Server 2012 is not supported by MS anymore: https://learn.microsoft.com/en-us/lifecycle/announcements/sql-server-2012-windows-server-2012-2012-r2-end-of-support

I would recommend moving to a more modern SQL Server version, like 2019 or 2022.

Re: Connecting to SQL Server 2012 from ArcGIS Pro

JeffWard — Tue, 06 Jun 2023 21:41:44 GMT

Thanks @George_Thompson , I'm looking at moving our database to another server. The one it is on now can't be updated due to other systems relying on it. Thanks for your help.