ERROR

Portal for ArcGIS connecting to SQL Server: Failure to access the DBMS server[ ]

Last Published: August 13, 2024

Error Message

When Portal for ArcGIS attempts to connect with a SQL Server database, the following error is returned:

Failure to access the DBMS server[]

Cause

This error is due to SQL Server disabling the Protocol Name for Named Pipes and TCP/IP.

Solution or Workaround

  1. On the server machine installed with SQL Server. Ensure that the Protocol Name for Named Pipes and TCP/IP is enabled, as shown in the image below. This setting can be changed in SQL Server Configuration Manager.

  1. Restart the SQL Server Services.

Article ID:000033361

Software:
  • Portal for ArcGIS
  • ArcGIS Pro

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options