Solved

Where do I create SQL Server Service Accounts?

Posted on 2009-05-17
5
436 Views
Last Modified: 2012-05-07
Hi

When setting up an account for each SQL Server Service are these created in the - SBS Users  - or - Users - part of Active Directory?

Does it matter?

Regards
William

AD.bmp
0
Comment
Question by:Whisky-Will
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 3

Assisted Solution

by:ddanonimity
ddanonimity earned 50 total points
ID: 24406464
I would say it doesn't matter  as long as you make sure they have the correct permissions for the account to run the required service
0
 
LVL 57

Expert Comment

by:Mike Kline
ID: 24406527
I've see a lot of organizations create an OU called "service accounts"
That way if you are ever making modifications it is really easy to exclude those accounts in that OU.
You could also add something to the description maybe like "serviceAccount"
Thanks
Mike
0
 

Author Comment

by:Whisky-Will
ID: 24406600
Hi
I have found some more information.
SBS USers: Default organisational unit for user accounts created with the Add New User Account wizard
Users: Default container for upgraded user accounts
As I created these accounts without using the Add New User wizard it looks like I should have created them in Users. Now when I try and move them I get a warning that If I move them things might not work because of the way group policies are applied.
Since being advised on this site to create separate accounts for each SQL service I just seem to be digging a bigger and bigger hole that I cant get out of.
At what level in my diagram should I create the new OU "Service Accounts" and can I ignore the error message and move the accounts there?
Regards
0
 
LVL 57

Accepted Solution

by:
Mike Kline earned 450 total points
ID: 24406612
We have our service accounts at the root so right click on the domain and select new OU
yes you can ignore the group policy warning, you shouldn't have issues there.
Thanks
Mike
0
 

Author Closing Comment

by:Whisky-Will
ID: 31582378
Thanks for your help guy's
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Group policies can be applied selectively to specific devices with the help of groups. Utilising this, it is possible to phase-in group policies, over a period of time, by randomly adding non-members user or computers at a set interval, to a group f…
Let's recap what we learned from yesterday's Skyport Systems webinar.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question