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

Windows AD Group >> Sysadmins SQL Server 2005 Expand / Collapse
Author
Message
Posted Wednesday, June 10, 2009 6:56 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, April 3, 2011 8:18 PM
Points: 47, Visits: 194
Hi there Everyone,

I have a Windows AD group call DB1SysAdmins
I put freddag into the DB1SysAdmins AD Group
I Add the DB1SysAdmins Login to DB1 (sql server 2005)
I add the DB1SysAdmins login into the server role "Sysadmin"

When I log onto Management studio as Freddag, it hasn't given me Sysadmin access. I run the is_rolemeber??? logged on as freddag and it returns 0..
If I add servers\freddag as a sql login and add this user into the sysadmin it works OK..

can you someone please clarify what i'm doing wrong?
cheers
Post #732694
Posted Wednesday, June 10, 2009 7:22 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:38 PM
Points: 2,047, Visits: 867
Have you logged on as Freddag after adding him to the AD group? His token won't include that he is a member of that group until it is regenerated, which is essentially at login.
Post #732699
Posted Thursday, June 11, 2009 12:10 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, April 3, 2011 8:18 PM
Points: 47, Visits: 194
Thanks, yea I logged off as that user and logged on again and it pickup the sysadmin role.

thanks
Post #732769
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse