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
6 Comments on “SQL Server __________ store logins and passwords in the master database.”
Chefsays:
C.
There are two authentications
Windows authetication
The credentials for which are not stored in SQl Server database and managed by windows/AD. There would be entry for windows autheticated logins in master database with respective SID but password would be with Active directory.
SQL Server authetication.
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 repective 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 orpahned users
C.
There are two authentications
Windows authetication
The credentials for which are not stored in SQl Server database and managed by windows/AD. There would be entry for windows autheticated logins in master database with respective SID but password would be with Active directory.
SQL Server authetication.
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 repective 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 orpahned users
3
0
C
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.Snapshots.html
SQL Server stores logins and passwords in the master database. Because Amazon RDS doesn’t grant access to the master database, you cannot directly import logins and passwords into your destination DB instance.
1
0
C.
does
0
0
I agree with the answer. C
0
0
Yes c
0
0
Yes its C
0
0