<div>
SQL Server stores the password user in <b>sys.logins</b> table in <b>master</b> database. You can query the table and check for the <b>password</b> column. It's encrypted, though.<br />

<pre><code class="code-1 nolinks" id="code-20-41536160-1"><span>SELECT *</span>
<span>FROM sys.syslogins</span>
</code></pre>
</div>


SQL Server stores the password user in sys.logins table in master database. You can query the table and check for the password column. It's encrypted, though.


SELECT *
FROM sys.syslogins


<div>
SQL Server stores the password user in <b>sys.logins</b> table in <b>master</b> database. You can query the table and check for the <b>password</b> column. It's encrypted, though.<br />

<pre><code class="code-1 nolinks" id="code-20-41536161-1"><span>SELECT*</span>
<span>FROM sys.syslogins</span>
</code></pre>
</div>


SQL Server stores the password user in sys.logins table in master database. You can query the table and check for the password column. It's encrypted, though.


SELECT*
FROM sys.syslogins


<div>
Thanks Victor, what encryption is used?
</div>


<div>
Many thanks for the fast replies
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts <br />
I have been doing some work recently in VB.Net about storing SQL passwords locally<br />
I'm wondering as a matter of interest, where and how does MSSQL store its own sa password <br />
on the server?
</div>
</div>


Hi Experts 
I have been doing some work recently in VB.Net about storing SQL passwords locally
I'm wondering as a matter of interest, where and how does MSSQL store its own sa password 
on the server?

MS SQL Security

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.