Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Service Accounts Expand / Collapse
Author
Message
Posted Wednesday, October 1, 2008 6:17 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 8:25 AM
Points: 246, Visits: 2,099
The question is, why is it recommended to use separate accounts for different SQL server services?

I have google-ised the question, but failed to find an answer.
Post #578992
Posted Wednesday, October 1, 2008 6:53 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 10, 2010 5:07 AM
Points: 2,661, Visits: 23,078
Here are a few things.

1) If someone happens to get the password for one of the services, it is nice if that does not mean they have the password for all of the services.

2) If a service account has been compromised and is misused, having it only associated with one service reduces the search area to find out what has allowed the breach and possibly who has made the breach.

3) Regular password maintenance will only impact a single service rather than every service.
Post #579019
Posted Wednesday, October 1, 2008 6:55 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 10, 2010 5:07 AM
Points: 2,661, Visits: 23,078
Think of it like physically having a key.

If someone steals your house key, isn't it more secure if they have to steal a second key to get into your office, your car, and your safe? If you happen to lose your key, do you want to have to change every lock you own because the key fits everything?
Post #579020
Posted Wednesday, October 1, 2008 7:55 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 8:25 AM
Points: 246, Visits: 2,099
Many thanks
Post #579068
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse