ssites
asked on
Sever running SQL Express 2005 upgraded to Domain Controller
First of all I'd like to acknowledge that what I did today was careless.
I have a server running SQL Express 2005 at Office B. I tried using Hamachi to promote the SQL Server to be an Active Directory Domain Controller with the domain located at Office A. It promoted fine and required a reboot.
Once rebooted, the SQL Service will not start. I decided I would just demote the SQL Server at Office B, but now (even with Hamachi up and running), it can not find the other domain controller to demote itself.
I know this is a mess, but I was hoping someone would have some good advice as to how to get myself out of this sticky situation. Please.
I have a server running SQL Express 2005 at Office B. I tried using Hamachi to promote the SQL Server to be an Active Directory Domain Controller with the domain located at Office A. It promoted fine and required a reboot.
Once rebooted, the SQL Service will not start. I decided I would just demote the SQL Server at Office B, but now (even with Hamachi up and running), it can not find the other domain controller to demote itself.
I know this is a mess, but I was hoping someone would have some good advice as to how to get myself out of this sticky situation. Please.
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
You can do this in the Services admin tool
- Go to Administrative Tools on the server, then to Services.
- Find the SQL Express services, and double-click on it
- Go to the Log On tab
- If it is set to "This account" you will need to either change to a different account that is on the domain, or try running SQL Express as the "Local System account". If you can, I recommend the latter option.
- Go to Administrative Tools on the server, then to Services.
- Find the SQL Express services, and double-click on it
- Go to the Log On tab
- If it is set to "This account" you will need to either change to a different account that is on the domain, or try running SQL Express as the "Local System account". If you can, I recommend the latter option.
ASKER
It wasn't the solution to my problem completely, but once I hurdle was crossed that was obviously the issue, this knowledge became very handy and expedited the process. Thank you.
Windows Server 2003
Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).
129K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER