Null password value in syslogins for master DB.

Gents,

I'm in an audit and I was asked by my syslogins are showing null password values for the master DB.  If I look at the permissions on the master Db I only have 5 accounts, 2 are service, and the rest built in.  Any ideas why these are showing up?  I'm on SQL 2008 R2, though I upgraded this box from SQL 2008.  I have attached a screen shot of the syslogins table as well as the permissions on the master db

Thanks.
Syslogins-table-with-Null-PW.JPG
Master-DB-Permissions.JPG
chilemooreDirector of ITAsked:
Who is Participating?
 
Scott PletcherConnect With a Mentor Senior DBACommented:
syslogins is an ancient view.  I believe it always returns NULL in the "password" column.
0
 
Anthony PerkinsConnect With a Mentor Commented:
As Scott has indicated and SQL Server's BOL confirms:
password   nvarchar(128)   Returns NULL.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.