Check How A Windows User Connects

You may see a Windows user accessing SQL Server but they are not showing as a login.

The following command should assist with showing which security group(s) gives them access.

EXEC xp_logininfo 'yourdomain\usersname','all';

Leave a Reply