SQL Server (dbname) service won’t start after promoting the server to a domain controller
When you promote your windows member server to a domain controller the SQL Server (dbname) service won’t start anymore.
The system event log notes error even id: 7024 “The SQL Server (dbname) service terminated with service-specific error 17113 (0x42D9).”
Solution: This is because the SQL Server (dbname) service is started under the local system account, this doesn’t work on a domain controller. Start the service under a user account with enough rights.
Monday morning my SQL 2008 R2 server worked just fine. After a reboot, it won’t start at all. I have spent hours upon hours trying different things suggested on the internet. It won’t start because of a log on error. I have a domain. I have one user. That user is the administrator. If that user doesn’t have the right to start SQL Server, then no one does. Can I just reinstall SQL server and not lose all the databases.
If you reinstall SQL the database would probably not replaced, it would be wise to be sure to detach the SQL database move it to another location and after reinstall you can just attach the database to the newly installed SQL server.