SQL Server Performance

Windows Groups and SQL users

Discussion in 'SQL Server 2005 General DBA Questions' started by smartrider, Nov 3, 2006.

  1. smartrider New Member

    I am trying to understand if I can do the following.

    Let's say there are 10 user in my Active Directory.
    I created a Group called - "Manager" and added 5 members in that group.

    Then I added that Windows Group to the SQL Server and gave access to databases.

    So everytime I try to login or create a connection using one of the user credentials that is in that group - I get an error that user doesn't exist or don't have access.

    What am I doing wrong?
  2. Adriaan New Member

    The connection settings must specify Windows Authentication.
  3. dineshasanka Moderator

    get the correct connection string

    Contributing Editor, Writer & Forums Moderator

    Visit my Blog at
  4. satya Moderator

    How that user group are connecting to SQL Server, is it via an application or SQL client tools?

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page