topic Re: Arcgis Pro 2.5 - SQL Database Connection in ArcGIS Pro Questions

Arcgis Pro 2.5 - SQL Database Connection

RickeyFight — Thu, 06 Feb 2020 23:46:07 GMT

So I just opened an old (pre 2.5) pro project and noticed that after the update data from a database connection would not load. I thought this was strange so I opened an brand new project and I get this error when trying to add a SQL database. My SQL Server Client software is updated.

Any ideas about how to to fix this?

Re: Arcgis Pro 2.5 - SQL Database Connection

MatthewSkewes2 — Fri, 07 Feb 2020 05:23:14 GMT

Yeah similar issues here connecting to SQL Server, hopefully it's an easy fix otherwise I'll have to roll back.

Re: Arcgis Pro 2.5 - SQL Database Connection

George_Thompson — Fri, 07 Feb 2020 11:53:31 GMT

I Just tested with ArcGIS Pro 2.5 and SQL Server 2017 and had no issues. I just upgraded from 2.4.3 yesterday. I was able to connect to all my geodatabases and non-geodatabases. I also tried OS and DB authentication with no issues.

What is the version of SQL Server being used?

Another option may be to reinstall the SQL Server Native client. I am not sure how the update would impact that but worth a try.

Re: Arcgis Pro 2.5 - SQL Database Connection

ThomasColson — Fri, 07 Feb 2020 14:23:54 GMT

Your quickest solution is going to be call Tech Support, but, if you could share (which they will also ask for)

What Vendor and Version of DB? What OS is it on? You say client is up to date, what version of client and when installed? Can you connect to the DB using other apps on same workstation (SSMS?)

Kory Kramer‌ will Microsoft SQL Server database requirements for ArcGIS 10.7.x and ArcGIS Pro 2.3 and 2.4—System Requirements | Documentat… be updated with 2.5 requirements?

Re: Arcgis Pro 2.5 - SQL Database Connection

KoryKramer — Fri, 07 Feb 2020 14:36:17 GMT

Yes, that documentation will be opening up soon with the release of 10.8...

Re: Arcgis Pro 2.5 - SQL Database Connection

KoryKramer — Fri, 07 Feb 2020 14:39:09 GMT

Check the odbc driver...

Re: Arcgis Pro 2.5 - SQL Database Connection

EthanGomberg — Fri, 07 Feb 2020 16:54:29 GMT

Yes this solved our connection issue.

Here is the link to the Driver we installed.

Download Microsoft® ODBC Driver 17 for SQL Server® - Windows, Linux, & macOS from Official Microsoft Download Center

Re: Arcgis Pro 2.5 - SQL Database Connection

KimberlyGraham1 — Fri, 07 Feb 2020 17:48:08 GMT

I had the same issue, the driver download fixed it. Thanks, Kory!

Re: Arcgis Pro 2.5 - SQL Database Connection

BradyMckenzie1 — Sun, 09 Feb 2020 23:44:50 GMT

Same here. The driver updated fixed it. Thanks muchly

Re: Arcgis Pro 2.5 - SQL Database Connection

JulieDel_Muto — Mon, 10 Feb 2020 21:28:23 GMT

What if your database is still on SQL 2012?

Re: Arcgis Pro 2.5 - SQL Database Connection

George_Thompson — Mon, 10 Feb 2020 22:13:05 GMT

I would recommend having it upgraded to a supported SQL Server version; Microsoft SQL Server database requirements for ArcGIS 10.7.x and ArcGIS Pro 2.3 and 2.4—System Requirements | Documentat…

It "may" connect and act like normal but then may also not work.

Re: Arcgis Pro 2.5 - SQL Database Connection

Anonymous User — Wed, 12 Feb 2020 14:46:21 GMT

2.5 broke my 2012 sql connections as well, but after reading this blog I decided to try Driver 11:

ODBC Driver 11 worked for me with SQL server (express) 2012 🙂

Re: Arcgis Pro 2.5 - SQL Database Connection

KeithMiller3 — Mon, 17 Feb 2020 21:13:28 GMT

I've found that installing the ODBC driver does work, but is MUCH slower than the native SQL driver used to be.

Re: Arcgis Pro 2.5 - SQL Database Connection

KoryKramer — Wed, 19 Feb 2020 16:27:57 GMT

FWIW on this thread, as far as we can tell, we think this occurs when a machine only has the SQL Server 2012 Native Client installed. Note that that client has not been supported since ArcGIS Pro 2.2. While it may have continued to work throughout Pro 2.3 and 2.4, it was not supported (see Microsoft SQL Server database requirements for ArcGIS 10.7.x and ArcGIS Pro 2.3 and 2.4—System Requirements | Documentat… ). As stated on this thread, for one user, updating to ODBC driver 11 resolved the issue for SQL Server 2012 but more importantly, as also noted above, be sure to check the requirements for ArcGIS Pro 2.5 here: Microsoft SQL Server database requirements for ArcGIS 10.8 and ArcGIS Pro 2.5—System Requirements | Documentation to ensure you are running a supported version of SQL Server along with a compatible driver.

I'm sharing this in the hope that it helps to clarify the situation based on the information we have. At this point, we have no indication that ArcGIS Pro 2.5 "breaks" database connections when running a supported version and compatible driver.

Thank you!