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?

PolyGeo ♦
65.5k29 gold badges115 silver badges350 bronze badges
asked Mar 22, 2017 at 10:30
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. Commented Mar 22, 2017 at 10:51
  • Do you have arcsde installed??? 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. 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. Commented Mar 22, 2017 at 11:50
  • do you have a user granted access for the DB server side? Commented Mar 22, 2017 at 11:58

1 Answer 1

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.
PolyGeo ♦
65.5k29 gold badges115 silver badges350 bronze badges
answered Mar 22, 2017 at 12:32

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.