Solved

Giving a domain group RW access to a DB?

Posted on 2010-09-06
3
455 Views
Last Modified: 2012-05-10
Hi,

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
0
Comment
Question by:Xeronimo
3 Comments
 
LVL 29

Accepted Solution

by:
Rich Weissler earned 500 total points
ID: 33612003
Have you already had the client PC log out and log back in since the group was added?
0
 
LVL 19

Expert Comment

by:Rimvis
ID: 33615172
>>I cannot connectWhat error do you get?
0
 

Author Closing Comment

by:Xeronimo
ID: 33616163
d'oh ... thanks.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Stored Procedure error 45 48
SQL help 5 51
How to import SQL 2000 database to SQL 2014 5 100
Table create permissions on SQL Server 2005 9 41
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

28 Experts available now in Live!

Get 1:1 Help Now