A new Active Directory junior administrator named Scott has just joined your organization. This administrator has just learned that the SQL Server is somehow using Windows used IDs for authentication. Scott has asked you what happens if he forces a password reset on a user that accesses SQL Server. What should you tell Scott?
Answer: – SQL Server when set to Windows Authentication mode uses the Active Directory assigned security token. When a password is reset, the user must signon wiith the new password. A token will then be assigned and used for authentication by SQL Server.(Active Directory users can access a SQL Server using Windows authentication regardless of any password change in Active Directory. This happens because SQL Server trusts the token issued by Active Directory. Local Windows users are not used and Windows passwords are not stored within SQL Server.)