Community
Select to view content in your preferred language

Failure to Access the DBMS Server on ArcCatalog 10.8.2

74
2
Monday
MatsHardy
by
Regular Contributor
Monday

I have installed ArcGIS Desktop 10.8.2 on Win 11 but later re-installed. After re-install, I cannot connect to the geodatabase in SQL Server. The error "Failure to access the DBMS server" is shown.

Failure_to_DBMS_01.png

But I can connect to the geodatabase by SQL management studio.

SQL_Studio_01.png

I have installed SQL Server native client, SQL Server ODBC server 17 & 18 but the error is still shown.

SQL_Client_01.png

Are there any ways to resolve the problem?

0 Kudos
2 Replies
George_Thompson
by Esri Notable Contributor
Esri Notable Contributor
yesterday

Did you re-install the SQL native client (Microsoft ODBC Driver 17 for SQL Server) after you re-installed ArcMap 10.8.2? https://desktop.arcgis.com/en/system-requirements/latest/database-requirements-sqlserver.htm

Also make sure to close and re-open ArcMap after you install the ODBC driver before connecting.

It looks like you are using SQL Server 2017, based on the screenshot above.

--- George T.
MatsHardy
by
Regular Contributor
yesterday

Many thx for your help. I have managed to connect now after adding TrustServerCertificate=yes to conneciton string.

0 Kudos