MSSQL UserAccounts and AD relations - security

  • 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?

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply