How to create a service account in AD

Srinivas_Vengala
Srinivas_Vengala used Ask the Experts™
on
Can someone please tell me how to create a service account (for SQL Server 2008 for example) in the Windows 2008 Active Directory? Is it using Active Directory Users and Computers tool only? Are there any differences between a normal user account and a service account creation?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Service accounts are just like any other user account.  You should develop standards for them though.  A common practice is to remove them from the Domain Users group (create a special group "service Accounts" and set their primary membership there).  THis will prevent them from being used to log into a desktop or server unless the server has explicitily granted permissions to the account.  
Commented:
No difference when you are creating the accounts.
Check below links if help you.

1. Setting Up Windows Service Accounts
http://msdn.microsoft.com/en-us/library/ms143504.aspx

2. Selecting an Account for the SQL Server Agent Service
http://msdn.microsoft.com/en-us/library/ms191543.aspx

3. How to: Set the Service Startup Account for SQL Server Agent
http://msdn.microsoft.com/en-us/library/ms186264.aspx

Commented:

If you're going to use kerberos authentication it may also be worth taking a look at the following:

http://social.msdn.microsoft.com/Forums/en/sqlsecurity/thread/1d47a68f-cdfa-4032-8ce4-0f1d08026219
A service account is a user account that is created explicitly to provide a security context for services running on Microsoft Windows Server.

One more link to Create a Service Account in windows.
http://technet.microsoft.com/en-us/library/cc739458(WS.10).aspx 

Author

Commented:
Thank you for your information. Oops..... I have actually created it in the Service Accounts and tried to use it in the SQL Server 2008 Cluster installation. I was giving wrong password as Caps Lock was enabled at the time the account was created. So, I have asked this question. Now I have recreated the account and it is working fine now.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial