[Webinar] Streamline your web hosting managementRegister Today


SQL Server 2005 Permissions

Posted on 2010-04-08
Medium Priority
Last Modified: 2012-05-09

I'm working with SQL Server 2005 and SharePoint 2003 and I was wondering if there is an easier way to add users to a SQL Server 2005 Database to assign permissions without first creating the users ad account in SQL Server Logins?
Question by:asp_net2
1 Comment

Accepted Solution

dbidba earned 2000 total points
ID: 30175345
Create an Active Directory global group for each different set of SQL Server permissions you need. Add all the domain user accounts which need the same rights into the appropriate Active Directory group. Then add that Active Directory group to SQL Server and grant appropriate rights to the AD group in SQL. AD group membership can then be controlled outside of SQL Server without the need to add/remove logins from SQL Server.


Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

612 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