nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ArcMap connect to SQL database

HendrikBritz1

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

Trouver plus de publications taguées avec

Geodatabase

Desktop

Accepted answers

HendrikBritz1

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

All comments

JeanettaWyman

To others experiencing this issue, I had the same problem and uninstalling all but one driver was still not working in both ArcMap and Pro. Had to install ODBC 17.3 for it to work in both, using map 10.8.2, Pro 3.2.3

BruceMillerRiv

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

LorindaGilbert

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

HendrikBritz1

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

HendrikBritz1

Yes I did install the sql native client

MikeVolz

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

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.