Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

sp_helplogins 'domain\account' Results Doesn't Match Management Studio Results Expand / Collapse
Posted Thursday, January 6, 2011 12:27 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, April 27, 2012 2:34 PM
Points: 43, Visits: 735

Any help is appreciated.

I've discovered that for some login IDs when I view the databases and permissions for a domain account in Management Studio >> Security >> Logins, it looks like this account is not setup in any databases.

When I run sp_helplogins for that same ID I get a list of databases and roles.

I've run sp_change_users_login 'Auto_Fix' for the ID for a database listed in the sp_helplogins results and receive ...

The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.

... and what's displayed in Management Studio >> Security >> Logins remains unchanged.

What can I do to correct the GUI display in Management Studio >> Security >> Logins?

Post #1043982
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse