patternsqlMinor
Does SQL Server care about the location of accounts in Active Directory?
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?
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.