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

MSSQL UserAccounts and AD relations - security Expand / Collapse
Author
Message
Posted Wednesday, December 19, 2012 10:32 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, June 25, 2014 2:22 PM
Points: 55, Visits: 165
MSSQL2000

In a Windows Authentication mode instance, if <domain>\<username> (say abc\def) has been been disabled on the Active Directory, does it matter that the same abc\def still exists as SYSADMIN on the instance level security logins?

For that matter, will it matter if it was in a mixed mode instance?

I don't think it matters because the authentication is deriving username / password from Active Directory. But, am I wrong?
Post #1398545
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse