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?