Viewing 3 posts - 1 through 3 (of 3 total)
xp_logininfo needs permissins at the server level (if NT group) or the domain level (if domain group) to read the group. The SQL account probably has that. The other account...
August 24, 2008 at 7:17 pm
#862349
Does the problem go away if you use SA or SQL Server Account as the owner? If so, the issue is not due to case sensitivity, it is because of...
August 22, 2008 at 9:10 am
#861970
Right click on SQL Server name in Management Studio and click properties.
Go to the Security Tab
Choose SQL Server and Windows Authentication Mode
Click OK
August 22, 2008 at 9:00 am
#861964