Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question

migrated from stackoverflow.com May 27 '10 at 23:43

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

1 Answer 1

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

 
discard

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