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

Posted on 2011-10-04
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
    LVL 25

    Expert Comment

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

    Expert Comment

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

    Author Comment

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

    Accepted Solution

    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

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    A quick step-by-step overview of installing and configuring Carbonite Server Backup.
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

    754 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

    24 Experts available now in Live!

    Get 1:1 Help Now