Giving login and database permissions to a group in SQL Server 2005

Tags:
SQL Server 2005
SQL Server permissions
Windows Server 2003
I am running SQL Server 2005 Workgroup Edition on Windows Server 2003 Standard Edition. I have created a global security group called ACSSales and I would like to give login and database permissions to this particular group, rather than individual user permissions. How do I do this?

Answer Wiki

Thanks. We'll let you know when a new response is added.

First you need to create a login to the SQL Server for that domain group. In Management Studio connect to the SQL Server in the object explorer. Navigate to the ServerName > Security > Logins. Right click on Logins and select New Login. Select the Windows authentication radio button and click the search button. Type in the name of your domain group and click Check Names. It should find it, then click OK (you may need to click advanced to get it to search easier. After you are back on the New Login screen select the User Mapping page on the upper left.

Put a check mark next to the database you want to give them access to, and in the box below select the role or roles you wish to give the users access to.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following