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.

This seems like a question that should be common enough, but I can't find anything on it. Two questions, really:

  • How can I determine which account(s) have Windows authentication access to an instance of SQL Server 2008?
  • Can I change that set of users without being able to log in to the SQL Server instance?

Thanks very much in advance!

share|improve this question
add comment

1 Answer

up vote 3 down vote accepted

The sys.server_principals view contains all the logins with access to the instance. You can filter by type U and G to get just Windows logins and Windows groups.

You can use the the T-SQL commands CREATE LOGIN, ALTER LOGIN and DROP LOGIN to manage logins without using the GUI. There are similar commands available for database users.

http://technet.microsoft.com/en-us/library/ms188786.aspx
http://technet.microsoft.com/en-us/library/ms189751.aspx
http://technet.microsoft.com/en-us/library/ms173463.aspx

share|improve this answer
    
I finally managed to get it working with your help - thank you very much! –  ladenedge Jun 21 '10 at 22:42
add comment

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.