Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 185
  • Last Modified:

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.
0
TECHADVICE
Asked:
TECHADVICE
  • 3
  • 3
1 Solution
 
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
 
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
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
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
 
Darius GhassemCommented:
Try your domain admin see if this it starts
0
 
TECHADVICEAuthor Commented:
dariusq:  That worked, thanks again.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now