How to determine membership in Windows Groups using T-SQL

I lead a recent server\database migration from SQL Server 2000 to SQL Server 2005. Several of my team were supposed to be added to a Windows group that was to have been granted access to the new SQL Server. We tested their access and they were not able to authenticate to the new SQL Server . Read my feature article on the SQL Server World Wide User Group website as I explain how I determined whether they were in fact members of a particular group.

Posted by Noah Subrin at 8/4/2008 7:14 PM
Categories: SQL Server
 

What did you think of this article?




Trackbacks
Trackback specific URL for this entry
  • No trackbacks exist for this entry.
Comments
  • No comments exist for this entry.
Leave a comment

Submitted comments will be subject to moderation before being displayed.

 Enter the above security code (required)

 Name

 Email (will not be published)

 Website

Your comment is 0 characters limited to 3000 characters.