I am getting an error message when atempting to Create a connection in Arc Catalog. The message is : Failed to Connect to database SDE not Running on Server Then I Check the Service esri_sde it has not started, so when I try to start it I get the message : The ArcSde Service(esri_sde)service on Local Computer started and them stopped. i found sde_esri_sde.log file . the error messages are : IDBInitialize::Initialize Failed DB_open_instance() PCC_connect error: 2 init_DB DB_instance_open_as_dba: -51 DBMS error code: 2 Microsoft SQL Server Native Client 10.0: Login timeout expired i dont know what's wrong ... ?! please help me
I suggest you check you connection properties. You were able to run sde post install cleanly? DId you used command line or GUI installation?
Can you connect to SQL Server via other tools? VIsual Studio or SQL Management?
I only ever used ArcSDE with Oracle but I guess its probably the same. When you say you can connect in sqlserver under which username? sde? Does the sde schema (login in sqlserver?) exists and all the tables created?. You are either using the wrong username/password or the sde schema has not been created. Does the sdemon command gives you a different error?
I think I have had this prob before.
If you are using (can't remember the name) ent/network authentication and your password has expired recently you need to go into the sql ?browser service and update the password. I also can't remember which service it is but I see brwoser, agent and sql server services. update one and see if sde will start.
It's a better practice to use direct connections to your database instead of SDE services. SDE services will consume CALS and if you don't less CALS than users you'll have a first come first served problem. ArcGIS 10.1 uses direct connect exclusively. Also, the answer about network logins is good advice to consider. Look up the way to use direct connect in ESRI help docs.
protected by whuber♦ Mar 29 '13 at 14:02
Thank you for your interest in this question.
Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?