Where are SQL Server user credentials stored?

Where are the SQL Server username and password stored?

+3
source share
1 answer

In a DB called "master", you can view them with

SELECT * FROM master.sys.syslogins

However, passwords are encrypted.

According to Richard’s remark: note that syslogins is no longer a physical table (in SQL Server 2005 and 2008), but only to represent backward compatibility.

+5
source

Source: https://habr.com/ru/post/1795457/


All Articles