1

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?

  • 2
    Please edit the question to clarify whether you are able to connect to another database in the same server, or able to connect to a different server from the same client. – Vince Mar 22 '17 at 10:51
  • Do you have arcsde installed??? – saviour123 Mar 22 '17 at 11:04
  • 1
    @saviour123 It is not necessary for an enterprise geodatabase to be enabled for a Desktop client to connect. It hasn't been possible to install ArcSDE in a long, long time. – Vince Mar 22 '17 at 11:10
  • 1
    It's been years since I last used SQL Server, but I expect you still need to grant logins access to databases and set up user-schema mappings before connection is possible. You should always troubleshoot connection issues from a Microsoft client if the Esri client isn't able to connect. – Vince Mar 22 '17 at 11:50
  • do you have a user granted access for the DB server side? – NULL.Dude Mar 22 '17 at 11:58
1

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.