June 7, 2017 at 12:49 pm
Hello,
do I have any way to check if the SQL Login accounts are hashed?
I tried to check in the syslogins view, but do not see any column which holds the value.
Please suggest if there is any way to get the details.
Thanks.
June 7, 2017 at 1:26 pm
The passwords for SQL logins are stored hashed. SHA_512 in 2012, no idea if that's changed since then
http://sqlity.net/en/2460/sql-password-hash/
syslogins is a deprecated view, included only for backward compatibility with SQL 2000, and should not be used any longer
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 7, 2017 at 4:41 pm
To expand on what Gail said, the sys.server_principals is the one to query for logins.
June 7, 2017 at 4:42 pm
Ed Wagner - Wednesday, June 7, 2017 4:41 PMTo expand on what Gail said, the sys.server_principals is the one to query for logins.
Or, for just the SQL authentication logins, sys.sql_logins
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply