topic Re: Database Connection to SQL Server SDE fail in ArcGIS Pro Questions

Database Connection to SQL Server SDE fail

KeithMortensen — Thu, 17 Mar 2022 23:03:56 GMT

Trying to make a Database Connection to our SDE on Sql Server.

I have a new machine: Dell, Win11, PRO 2.9, ArcGIS 10.8.1.

All the other machines on the premises with various operating systems all work. win10 and win11. Ive installed all the ODBC clients from 11 to 17. I can access my SDE server from SSMS and making a new OLE DB Connection in Pro. I've uninstalled and reinstalled every version of Pro from 2.3 to 2.9.

What am I missing?

Thanks

Re: Database Connection to SQL Server SDE fail

KimberlyGarbade — Fri, 18 Mar 2022 02:50:28 GMT

When you create a successful connection to a SQL Server instance ArcGIS Pro creates a "NameOfTheConnection.sde" file on a drive somewhere. You can use this connection to connect to the database using the "Add Database" option instead of the "New Database Connection" option. Can you reference, or copy a successful .sde file from one of the other computers that can connect, to a network drive you have access to and try that file? If it works or if it doesn't... either way its a clue to what's going on creating a new connection.

Re: Database Connection to SQL Server SDE fail

George_Thompson — Fri, 18 Mar 2022 10:21:55 GMT

Did you install the 64-bit clients on the machine?

What is the version of SQL Server being used?

Is SSMS on the same machine as Pro?

Try uninstalling all the ODBC clients besides the latest version.

Re: Database Connection to SQL Server SDE fail

KeithMortensen — Mon, 21 Mar 2022 14:23:30 GMT

Great idea, but it didn't work. At least it tells me the the connection parameters Im using are correct.

Re: Database Connection to SQL Server SDE fail

KeithMortensen — Mon, 21 Mar 2022 14:24:58 GMT

Thanks for the reply. All 64 bit clients. SSMS is on the same machine as pro. Ill try reinstalling ....

Re: Database Connection to SQL Server SDE fail

KimberlyGarbade — Mon, 21 Mar 2022 14:41:42 GMT

When you say it didn't work what do you mean (I.E. What message does it give you when you click which button)?

Also, when you open the connection file's "connection properties"; if you don't change the username and password, can you click on the "Database" dropdown and see the name of the database you are try to connect to? Is it only when you hit "OK" that it gives the message?

Re: Database Connection to SQL Server SDE fail

KeithMortensen — Mon, 21 Mar 2022 15:09:41 GMT

I put an image with the original post to show the error, but it wont even pull up the list of databases. also of note, I can see via the ssms some of my login attempts to the db. specifically the ones where I had a typo in the password.

Re: Database Connection to SQL Server SDE fail

KeithMortensen — Mon, 21 Mar 2022 16:30:00 GMT

sql server 2016. I uninstalled everything but odbc c driver 18 and Im getting a an error that its trying to connect with client software version that is too old. grrr

Re: Database Connection to SQL Server SDE fail

George_Thompson — Mon, 21 Mar 2022 16:34:46 GMT

What is the version of the geodatabase?

Look in the VERSION table.

Re: Database Connection to SQL Server SDE fail

BillFox — Mon, 21 Mar 2022 16:49:13 GMT

yes, I have seen problems too having extra ODBC clients installed at the same time - (ditto) remove all but latest.

ArcGIS 10.9.1 and ArcGIS Pro 2.9 requirements for Microsoft SQL Server

https://enterprise.arcgis.com/en/system-requirements/latest/windows/database-requirements-sqlserver.htm

Re: Database Connection to SQL Server SDE fail

KeithMortensen — Mon, 21 Mar 2022 18:30:56 GMT

Here is the current error. message about an older client is now gone. both logins Im trying on the new machine work on the old machine....

Re: Database Connection to SQL Server SDE fail

KeithMortensen — Mon, 21 Mar 2022 19:59:48 GMT

10.8.xxx I just closed it and forgot to note it....

Re: Database Connection to SQL Server SDE fail

BillFox — Mon, 21 Mar 2022 21:19:17 GMT

Are you including the <server-name>\<instance-name> in that Instance box?

Did you reboot after the uninstalls/re-installs?

just ODBC client v17?

Re: Database Connection to SQL Server SDE fail

KeithMortensen — Mon, 21 Mar 2022 22:19:01 GMT

Im not entirely sure what our <server-name>\<instance-name> is.... I typically put the just the server name in there. Ive tried the address for it as well, which is defined in the Hosts file.

I did reboot after uninstalls and installs. and I followed the clean uninstall from esribelux. upon reinstall of the odbc client 18 and ssms it shows I have both the odbc drivers for 17 and 18.

Thanks for your time on this

Re: Database Connection to SQL Server SDE fail

KimberlyGarbade — Tue, 22 Mar 2022 00:12:24 GMT

I usually steal the instance name right from SSMS when I can't remember it (which is more often lately). Its the same as the Server name in the SSMS database connection dialog:

Re: Database Connection to SQL Server SDE fail

KeithMortensen — Tue, 29 Mar 2022 20:58:53 GMT

So after everything we tried over here, Jeff and Lisa from ESRI helped out. We found out, besides sql native client 10, the only other thing that was different was the old machine had odbc driver 13, and the new machine had everything BUT that. So we got rid of odbc 17 and 18 and installed 13 and it worked.

Thanks for everyone's help in trying to solve this hair removing issue

Re: Database Connection to SQL Server SDE fail

L77 — Tue, 03 May 2022 00:12:48 GMT

I had this issue today where I upgraded from Arc Pro 2.4 to 2.9, then I couldn't connect to the databases in ArcPro, ArcMap or ArcCatalog. I downloaded the ODBC driver 17 and didn't know that I already had ODBC 18 installed so I lost connection to the databases.

After uninstalling ODBC 18, I immediately gained connection to all of my databases again. So this definitely works to uninstall the extra drivers.