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?

Improve this question
8
  • 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
    Commented Mar 22, 2017 at 10:51
  • Do you have arcsde installed???
    – saviour123
    Commented Mar 22, 2017 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
    Commented Mar 22, 2017 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
    Commented Mar 22, 2017 at 11:50
  • do you have a user granted access for the DB server side?
    – NULL.Dude
    Commented Mar 22, 2017 at 11:58

1 Answer 1

Reset to default
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.
Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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