SQL Express has stopped working after promoting the server to a DC

Posted on 2010-04-05
Medium Priority
Last Modified: 2012-05-09

We have a server running Server 2008 Standard,  It is running an instance of SQL Express, which has a small 500MB database for a CRM application.  We promoted the server to a DC temporarily to get a full time replacement in place during a migration.  Now we are having trouble accessing the CRM (non-critical), and its spitting an error no matter what we try:

an error occurred in method UseLogin. PopulateDatabaseList: A network related or instance specific error occurred while establishing a connection to SQL server. The server was not found or accessible. Verify that instance name is correct and that SQL server is configured to allow remote connections

We have tried running the app from 3 different machines, and on the server itself, and still the same error.  What do we do?

Question by:paylessoffice
  • 2
  • 2
LVL 72

Accepted Solution

Qlemo earned 2000 total points
ID: 29798606
Go into the service applet and reapply the service credentials. Then restart the MSSQL services. If you do not have a SPN issue,  this helps.
If you have a SPN issue, you need to issue an setspn. SPN is Server Principal Name, a registration of the MSSQL service in AD.

Author Comment

ID: 29803720
How do I reapply the service credentials?
LVL 72

Expert Comment

ID: 29805299
Go into the Services applet, open the individual service properties (at least for the MSSQL Server instance), and change the login info forth and back.

Author Comment

ID: 29907389
Thanks!  We got it, it was the service account credentials.  After I reset them, it worked...

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
Exchange database can often fail to mount thereby halting the work of all users connected to it. Finding out why database isn’t mounting is crucial and getting the server back online. Stellar Phoenix Mailbox Exchange Recovery is a champion product t…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…
Suggested Courses

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question