topic Database connection error in Geodatabase Questions

Database connection error

Abi — Fri, 16 Feb 2024 16:22:13 GMT

All effort to connect an existing Arcmap user to the database (sde) has proved futile. The user recently just changed his machine to a new one , and anytime I try to connect , I keep getting

"Unable to connect to database server to retrieve database list;please verify your server name and password info and try again"

How do I rectify this error message?

Re: Database connection error

George_Thompson — Fri, 16 Feb 2024 16:43:04 GMT

What version of ArcMap are you using?

What is the RDBMS and version being used?

Does ArcMap have the correct version of the client drivers installed?

Re: Database connection error

Abi — Fri, 16 Feb 2024 19:08:57 GMT

ArcMap Version is 10.8.1.

RDMS - Microsoft SQL Version 2019

Version installed on driver is 10.8.1.

Re: Database connection error

George_Thompson — Fri, 16 Feb 2024 19:24:55 GMT

Is the SQL Server running on a custom port?

Can you install SSMS on the ArcMap machine and make a connection with SQL Server?

What specific ODBC driver is installed: https://desktop.arcgis.com/en/system-requirements/latest/database-requirements-sqlserver.htm#ESRI_SECTION1_B75DB4BEF4BF40348621F378FB8F9FD8

Have you rebooted the machine since the install of the ODBC driver?

Re: Database connection error

DavidPike — Fri, 16 Feb 2024 19:45:49 GMT

Yes agree. Error message seems like a red herring and is likely the driver.

Re: Database connection error

Abi — Thu, 22 Feb 2024 18:36:36 GMT

Thank you All for your help. I was able to resolve it installing ssms and updatng the license type from standard advance.