SQL Server Performance

sql server 2008 Windows groups

Discussion in 'SQL Server 2008 General DBA Questions' started by mc_tiger, Apr 20, 2009.

  1. mc_tiger New Member

    I have created a windows security group in AD and added myself as a user to this group. I then added this group to sql 2008 and made this the owner of a DB. However, when I try to login to sql server as that user I get access denied.
    Not sure if I am missing something to get Windows groups to work.
    Thanks,
  2. MohammedU New Member

    Make sure login is not disabled in SQL.
  3. satya Moderator

    Are you able to connect to the instance or getting access denied on the database level?
  4. mc_tiger New Member

    getting access denied for the user xxx.
    however, if i explicitly add that user and log in the sql server with windows authentication...that works
  5. satya Moderator

    Capture the complete error message and post here, it seems some information is missing.
  6. ashish287 New Member

    do you mean that you made a group to owner of a perticualr datababse?

Share This Page