Giving login and database permissions to a group in SQL Server 2005
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?
Software/Hardware used:
Software/Hardware used:
ASKED:
August 4, 2008 2:20 PM
UPDATED:
August 4, 2008 9:19 PM
RELATED QUESTIONS
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.