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.

In my company we have a number of databases in an MS SQL instance. This morning only 1 database i generating following error when I try to do a direct-connect in ArcCatalog:

Failed to connect to database. Underlying DBMS error[sde.DEFAULT][STATE_ID = 1]

I have increased the number of allowed connections to 10 000 and that's is more than enough. Still the problem exists. Does anyone have a clue? :)

share|improve this question
1  
Check sde error logs on the server (in the etc directory under $SDEHOME)) –  Sunil Mar 8 '13 at 13:02
1  
Which SDE you are using (9.x or 10 ? ) –  Sunil Mar 8 '13 at 13:07
    
+ 1 how do you connect SDE through catalog or arcmap ? –  Sunil Mar 8 '13 at 13:11
    
What do the database logs say? –  Devdatta Tengshe Mar 11 '13 at 10:57
    
Hi. been away for a couple of days. We are not using ArcSDE in that way. We use direct connections to the SQL database and instance. The only thing that seems to solve the connection problem is to kick all users than do an restore of the database. It has now happened 2 times in a week. –  nick anderson Mar 14 '13 at 14:14
show 3 more comments

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.