Giving a domain group RW access to a DB?
Posted on 2010-09-06
I've created a global security group called 'SQL_OVS' in my Windows 2003 domain and I've added some users to that group.
I now want to give that group read-write permissions on an SQL 2005 database.
I've connected to that SQL Server 2005 (using the SQL Server 2008 Management Studio) and added the group as a login user under 'security'. Its database role membership is 'public', 'db_datareader' and 'db_datawriter'.
Yet, when I try to create an ODBC connection on a client PC with a user from the SQL_OVS group I cannot connect!?
What am I doing wrong?
Thank you very much