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
    http://www.connectionstrings.com/

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  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
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.

Share This Page