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
http://www.connectionstrings.com/ —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

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.

]]>