Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Effective Permissions for a group Expand / Collapse
Author
Message
Posted Wednesday, October 27, 2010 2:58 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, November 06, 2011 9:39 PM
Points: 5, Visits: 25

Version - SQL Server 2005 SP3

I have added some users to the group "PROD\SEA-SQL-READ" and gave them read access to the group. But when I click Effective permissions I get the below error.


Cannot execute as the server principal because the principal "PROD\SEA-SQL-READ" does not exist, this type of principal cannot be impersonated, or you do not have permission. (Microsoft SQL Server, Error: 15406)



Thank you all in advance
Post #1011902
Posted Wednesday, October 27, 2010 3:12 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, April 18, 2014 8:31 AM
Points: 2,285, Visits: 4,222
It is a bug in SQL Server 2005 Managment Studio. The fix suggested by MS is to use the SQL Server 2008 Managment Studio.

SQL = Scarcely Qualifies as a Language
Post #1011911
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse