Where are SQL Server user name and password stored?

In the DB called "master", you can view them with: <pre class="prettyprint"><code>SELECT * FROM master.sys.syslogins </code></pre> 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.

Where are SQL Server user credentials stored?

1 Answers

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.