Windows Groups and SQL users | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Windows Groups and SQL users

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?

The connection settings must specify Windows Authentication.
get the correct connection string —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at

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.