HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Does SQL Server care about the location of accounts in Active Directory?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
directorytheactivesqlcareaboutdoesserveraccountslocation

Problem

Some maintenance is being worked on in our Active Directory here and my supervisor asked me if SQL Server cared about the location of security and service accounts.

I told him I didn't think it did but I wasn't 100% sure.

So, for service accounts and security groups used to control access to the database, does SQL Server care where they are in Active Directory?

Solution

No SQL Server doesn't care where in the OU the account and/or groups are. Everything is done via SIDs, or in the case of the service accounts with the actual username and password to startup the service.

Context

StackExchange Database Administrators Q#34273, answer score: 3

Revisions (0)

No revisions yet.