ArcMap connect to SQL database

1320
5
Jump to solution
07-22-2022 12:33 AM
Labels (2)
HendrikBritz1
New Contributor II

Hi Community

I'm trying to connect to a sql database via ArcMap 10.8.2 on windows 10 Pro. Get the "Unable to connect to database server to retrieve database list......" error. I use the same credentials in ArcGIS Pro and in sql server manager and it works there, but not in map. Any ideas why?

Thank You

Tags (3)
0 Kudos
1 Solution

Accepted Solutions
HendrikBritz1
New Contributor II

I read from a previous post that there should only be one odbc driver version installed, so I uninstalled the others and only kept odbc sql 17. and did solve the issue for me

View solution in original post

5 Replies
MichaelVolz
Esteemed Contributor

Did you install the proper native client to connect to a SQL Server database in Pro?

0 Kudos
HendrikBritz1
New Contributor II

Yes I did install the sql native client

0 Kudos
HendrikBritz1
New Contributor II

I read from a previous post that there should only be one odbc driver version installed, so I uninstalled the others and only kept odbc sql 17. and did solve the issue for me

LorindaGilbert
Occasional Contributor II

This was an issue that we had after upgrading from 10.7.1 to 10.9.1 for Server, and 10.8.2 desktop.  Had a call into tech support as well. 

We did have 2 or 3 SQL drivers installed - we've done this MANY times in the past on previous servers and desktops.  Uninstalled all but 17 and low and behold it all worked as it should - Server and Desktop.  Now will mention that the 18 driver didn't work.  So we uninstalled it and reinstalled just the 17 driver and all played very well together.

We had the tech support for Server on the horn for at least three days, asking questions of other tech nearby, no one asked about this or even mentioned it.  We kept getting certificate errors with the registration of the databases for Server.  New certs, everything, security team helping, nothing would work.

We were confused as all get out about why we were getting certificate errors on desktop as well as server - that had never happened in the past.  So I did a quick search and found this thread, tried it and have to say thanks to HendrikBritz1 for posting what you had found on another thread.  Of course, will have to say that we didn't expect it to fix both issues at the same time, but are extremely happy it did.

Lorinda

0 Kudos
BruceMillerRiv
New Contributor

Just had this issue. Deleting all other ODBC connections except for 17 fixed it. Thanks for this post! It was driving me crazy.

0 Kudos