Let me preface this by stating that I am more of a UNIX guy and this is making me pull my hair out. I have a Windows 2003 server that is running SQL Server 2005 for VMware's Virtual Infrastructure system. The theory was to make this system an Active Directory controller but we have decided to hold off on that for now. I demoted the server out of Active Directory land (no longer a controller or a member of any Active Directory). Unfortunately when I do that, the SQL Server service will no longer start.
When I go into the SQL Server Configuration Manager and try to change the Log On to the Administrator account or one of the built in accounts I get the error "No mapping between account names and security IDs was done".
How can I fix SQL Server so that it's not thinking about Active Directory permissions and account IDs?
Best Answer
Kind of a brute approach, but have you tried uninstalling and re-installing SQL Server? If it won't let you, you might try these steps.
As another option, you could try these steps to fix the local account SID issue, but it looks like kind of a pain.