Getting DBMS error on connection to database (ArcCatalog/SQL server)

Luciečervená

Hi, 

after recovery our database server and pc for arcgis server/desktop etc I am getting at crating new database connection in ArcCatalog:

"Unable to connect to database server to retrieve database list; please verify your server name, user name and password info and try again. Failure to access the DBMS server"

Steps already done: 

1. Recreated database connection in ArcGis Pro Catalog view - working in ArcgisPro, not working in ArcCatalog (Failed to connect to database. Failure to access the DBMS server)
2. .NET 4.7 is installed, register Key  "[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\v4.0.30319]
   "SystemDefaultTlsVersions"=dword:00000001" applied, "TLS 1.2 support for ArcGIS Desktop” ignored because we have 10.7 version (ArcGIS Desktop 10.7: This release shipped in the first half of 2019 and is configured to use TLS 1.2 – no action is necessary. Esri recommends upgrading to this release when ArcGIS Desktop 10.7 is available.)
3. pinged: sqlcmd -S servername -U USER -P password - for local user (which is log in to ArcCatalog) getting "login error: Login failed for user USER; for database user getting "1>"
4. reinstalled "Microsoft ODBC Driver" 17+18 for 32 bit - didn't change anything

I would like to switch all work from desktop to ArcGis Pro, but even after 3.6.0 update we are not able to manage privileges for more than 1 item, and i am not gonna change it one by one for more than 100 items (again 😞 )

 

ShannonShields

Given that you are also getting a login error using sqlcmd, this isn't an ArcGIS problem.

When you restored this database was it to a new/different instance of SQL Server? Did you re-create the login and link it to the user in the restored database?

If you are using a database login (e.g. not Windows login) then you'll need to re-link it to the database user using the ALTER USER <username> WITH LOGIN = <loginname> command.