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; } } }

Database Connection to SQL Server SDE fail

KeithMortensen

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

SDEerror20220317.png

Encontre mais publicações marcadas com

Geodatabase

Desktop

Feature Services

Accepted answers

KeithMortensen

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

All comments

L77

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.

KeithMortensen

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

KimberlyGarbade

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:

KeithMortensen

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

BillFox

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

Did you reboot after the uninstalls/re-installs?

just ODBC client v17?

KeithMortensen

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

KeithMortensen

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....

BillFox

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

George_Thompson

What is the version of the geodatabase?

Look in the VERSION table.

KeithMortensen

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

KeithMortensen

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.

KimberlyGarbade

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?

KeithMortensen

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

KeithMortensen

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

George_Thompson

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.

KimberlyGarbade

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.

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

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