Prev Question
Next Question

SQL Server __________ store logins and passwords in the master database.

A.
can be configured to but by default does not

B.
doesn’t

C.
does

Explanation:
There are two authentications
Windows authentication
The credentials for which are not stored in SQL Server database and managed by windows/AD. There would
be entry for windows authenticated logins in master database with respective SID but password would be with
Active directory.
SQL Server authentication.
For 2nd we have password stored in hash format you can see it from sys.sql_logins. The information about
SQL server logins are stored in master database and each login has SID receptive to it. Only SA login has
same SID no matter what server it is. That is why when you move database by backup restore mechanism
users are moved not logins and you finally have to create logins(if already not there) and map it to users. This is
generally called as troubleshooting orphaned users

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *