Logins with null passwords | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Logins with null passwords

Why does this script return logins with null passwords, even when I’m sure the passwords in some cases are not null USE MASTER
Select name, password
from syslogins
where password is null
order by name

I think it returns the windows builtin users with null passwords.
No, it just refuses to show you the actual password! If the password is null, then the password column will say NULL – which is a bit inconsistent, but it does show you which logins do not have a password. Ranitjain is correct that the password returned for Windows logins will always be null here. CORRECTION:
If the password is shown as a blank then it’s a SQL Server login, if it’s shown as NULL then it’s a Windows login.