Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've built and installed a SQL database and client application. It all works well generally, but intermitently (normally first thing each morning), the client application reports an Error 26 - error locating server instance. Each time this is resolved by Restarting the SQL Server Browser on the server. It is as if SQL Server Browser stops running over night.

I have SQL Server Browser startup set to 'Automatic' so I fail to see why it would keep stopping in this way.

Has anyone encountered this issue before, or have any ideas what might be causing it?


migration rejected from Sep 29 '13 at 16:39

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off-topic by Max Vernon, Paul White, Mat, ypercubeᵀᴹ, Mark Storey-Smith Sep 29 '13 at 16:39

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Max Vernon, Paul White, Mat, ypercubeᵀᴹ, Mark Storey-Smith
If this question can be reworded to fit the rules in the help center, please edit the question.

Please , send me screenshot of error? – vikram jain Oct 11 '12 at 10:46
Check the event log on the server (both Application and System). There should be a record indicating why the service stopped. – tobias86 Oct 11 '12 at 10:50
Does restarting the client solves this issue? – dezso Oct 11 '12 at 11:18