Added Active Directory Services to Server, now SQL will not start

I added Active Directory Service to existing Server so that we could easily add computers into a domain, and now the SQL Server will not start.  SQL was already loaded on the machine.  I'm thinking that the new domain setup is causing an issue, but not sure how to troubleshoot.
TECHADVICEAsked:
Who is Participating?
 
Darius GhassemCommented:
Try your domain admin see if this it starts
0
 
Darius GhassemCommented:
Correct when you install AD on a server you local users and groups get disable which causes other services that were running on local accounts to stop working. Plus local security policy is not active anymore as well you must configure  the proper GPO User Right Assignment polices to allow for certain users to run services on the domain controllers in Domain Controller GPO.

For this reason the recommendation is not to install AD on boxes that will be running other services.
0
 
TECHADVICEAuthor Commented:
Sounds like it is possible, right?
Once I add the correct users, is a restart required/recommended?
-- Can you be more specific on the proper GPO User Right Assignment policies? I just want the service to run and not as concerned with group policy mgt.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Kiran ChCommented:
hi, please try this MS KB if it solves : http://support.microsoft.com/kb/929665
Or also it depends on which sql versions are running on as they are chances of issue not getting solved too. http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/2c06b24c-a86c-4a5d-8e08-58b1f7df3eb1/
0
 
Darius GhassemCommented:
First go to  the services of SQL check to see what username is attached to that permissions to the service to start
0
 
TECHADVICEAuthor Commented:
dariusq:  username is "Network Service"
0
 
TECHADVICEAuthor Commented:
dariusq:  That worked, thanks again.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.