Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Hi How can I set permissions againt existing windows groups in sql server 2005

share|improve this question

migrated from May 27 '10 at 23:43

This question came from our site for professional and enthusiast programmers.

Expand the Security in Management studio, Right click on Logins and select new, Hit the Search button next to Login Name,

hit the Advanced button Click on Find now Your Groups/logins will appear in the search results. Select Groups/Logins

close all open dialogs by clicking ok Now you have a login

Associate the login / group to Databas object(s) by right clicking on the Database (name) and permissions- You can also associate permission to child objects of the database (Tables/Sps etc) individualy

share|improve this answer
Thanks I have done that but when it comes to assigning the permissions, Sql does not seem to be able to find the logins for Windows group, It only seems to be able to find User and Database role object types and the new login created is never found – ruben May 27 '10 at 11:27
@ruben - are you working directly on the server, or through a remote management console? Either way, are you logged in with a domain account, or a local account? – MDMarra May 27 '10 at 23:46

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.