sql server 2005 cannot add rights to AD groups to access databases

Posted on 2011-10-04
Medium Priority
Last Modified: 2012-05-12
windows server 2003 DC, SQL Server 2005 SP4 devlp. ed., new installation.

cannot add rights to AD groups to access databases

Question by:donOttavio
  • 2
LVL 25

Expert Comment

ID: 36909501
Setup is made for 'windows authentication' or both 'sql and windows authentication'?
LVL 14

Expert Comment

ID: 36909558
What are trying to do?  You add the domain groups to the SQL instance via the management studio

Author Comment

ID: 36910199
windows authentication only.
I need domain user group to have right to access and read from specific database.
LVL 14

Accepted Solution

Vinchenzo-the-Second earned 2000 total points
ID: 36910424
You need open up SQL management studio, expand security, right click logins and choose new login. Select your Ad group, then click on user mappings, and give read only access to the database

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

In the absence of a fully-fledged GPO Management product like AGPM, the script in this article will provide you with a simple way to watch the domain (or a select OU) for GPOs changes and automatically take backups when policies are added, removed o…
High user turnover can cause old/redundant user data to consume valuable space. UserResourceCleanup was developed to address this by automatically deleting user folders when the user account is deleted.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…

864 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