How to recover from SharePoint configuration errors after promoting the server to a Domain Controller

sharepointsharepoint-2010windows-server-2008

I have a SharePoint 2010 VM setup in VirtualBox and I was using local machine accounts to handle security on the server.

While preparing for a demo it came time to have some meaningful users on my VM image. I followed some docs on promoting my server to a Domain Controller in a new forrest.

So now I have [MachineName].SPDEMO.CONTOSO.com and I can add users as needed.

However, when I try to connect to my SharePoint sites I am getting a white screen with the error:

"Cannot connect to the configuration database"

I changed the pool identity account of each of my IIS app pools to the new Administrator account and started the services successfully but I can't get the SQL services to start up.

When I try to start them I get the following error:

Windows could not start the SQL Server (MSSQLSERVER) on Local Computer. For more information, review the System Event Log.  If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 17058.

In the event log I see the following error:

The SQL Server (MSSQLSERVER) service terminated with service-specific error %%17058.

Can I recover from this or should I roll back or just uninstall the Domain Controller role. I'd like to keep the server as a standalone DC so I can do some user profile creation/management but I need the SharePoint bits to work as well.

Best Answer

It's probably a problem with SQL Service account, have you changed it?