Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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

share|improve this question
2  
please change your 0% accept rate so you will get response to future questions. –  Brad Nesom Jul 10 '11 at 4:02

4 Answers 4

up vote 3 down vote accepted

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?

share|improve this answer
    
i can connect to sql server via sql management . i used command line to start service but it didnt work(sdemon -o start -i esri-sde -s majid-PC) –  wetland Jul 9 '11 at 15:10
    
@GISlove That just indicates that SQL Server is running, not that SDE is working. You need to resolve the SDE issue (perhaps a username/password problem?) before you can use ArcCatalog to connect to SDE. –  Michael Todd Jul 9 '11 at 16:01

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.

share|improve this answer
    
I agree with you . direct connection is better because it doesn't need to start services –  wetland Mar 29 '13 at 11:15

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.

share|improve this answer
    
thank you so much . –  wetland Jul 10 '11 at 5:11

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?

share|improve this answer

protected by whuber Mar 29 '13 at 14:02

Thank you for your interest in this question. Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.

Would you like to answer one of these unanswered questions instead?

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