Where are SQL Server user credentials stored?

Question

Where are SQL Server user name and password stored?

Answer 1

In the DB called "master", you can view them with:

SELECT * FROM master.sys.syslogins

However passwords are encrypted.

As per Richard's comment: please note that syslogins is no longer a physical table (in SQL server 2005 and 2008) but only a view provided for backwards compatibility.