Thursday, May 15, 2008

Add Windows domain group into SQL Server 2005 Login list

To add a Windows user group as a SQL Server 2005 login:

  • Under Management Studio, right click on Security\Logins, and select "New Login ...".
  • In the "Login - New" window, click [Search..]
  • Check the "Groups" checkbox, then click [OK]
  • Click [Advnaced]
  • Click [Object Types]
  • Make sure the location is listing the right machine or domain, otherwise click [Locations...] in case you need to change.
  • Click [Find now]
Your domain group should be in the list.

0 Comments:

Post a Comment

<< Home