SQL Server user names and passwords

Question

Where SQL server user names and passwords are stored in SQL server?

Jignesh Trivedi · Answer

hi please refer http://www.akadia.com/services/sqlsrv_logins_and_users.html and also check  sys . server_principals http://msdn.microsoft.com/en-us/library/ms179503.aspx hope this help.

Satyapriya Nayak · Answer

Hi Sanjoli They are stored in master db in the sysxlogins table. Thanks

Hemant Kumar · Answer

Sql Server UserNames and Passwords are stored in master database. Master database stores login informations. To see all the available login username and password select * from master..syslogins