Viewing Logins

Viewing Microsoft® SQL Server™ logins can help you determine if a user or Microsoft Windows NT® group has permission to connect to SQL Server and which databases the login can access. Viewing a login before removing it can be used to show which database users must be removed first (because it is not possible to remove a login without first removing the associated users.)

Information that can be viewed about each login includes:

• Users in each database associated with the login
• Default database and language the login uses when the user first connects to SQL Server
• Windows NT security identifier (SID).

Note It is not possible to view the password of any login unless the password is NULL. Passwords are encrypted when stored in SQL Server.

To view a SQL Server login or Windows NT user or group