SQL Express has stopped working after promoting the server to a DC
Posted on 2010-04-05
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?