[GIS] Unable to connect to database from ArcMap

arccatalogarcgis-desktoparcmapsql server

I am trying to connect to SQL Server database from ArcMap from the same instance. I am able to connect one database; to another database I am unable to connect.

I am getting this error while connecting:

Failed to connect to specified server. Do you want to
proceed? Operation failed.

What might be wrong?

Best Answer

Make sure of these points:

  1. Have you installed SQL Server compatiable version. If not please make sure that you have compatiable sql server client installed.
  2. Have you recently restored you SDE database into another database. If that's the case then there is conflict between the configuration of SDE generated schema, as it will hold the name of previous database but your current new database name is Changed.
  3. Normally, these types of errors occur, if there is something wrong with the ArcSDE schema of sql server database.
Related Question