August 13, 2014 at 2:21 pm
I have an application that uses an AD service account domain\username. The service account is part of a security group that has read write execute permissions on a databases. I have the same group across multiple instances and it has been working for over 2 months. All of a sudden last week and the week before two of the 48 instances started getting authentication errors. The only way I have been able to fix it is to add the individual service account to the instance and give it the same permissions . Has anyone else ever run into this issue?
August 13, 2014 at 5:04 pm
What is the difference in the output of xp_logininfo for one of the affected logins when you run it on one of the two servers affected versus one of the 48 servers not affected
August 13, 2014 at 7:09 pm
The results are the same. for XP_logininfo - this is the results
Account name type privilege mapped login name permission path
Domain\Username user user domain\username domain\SecurityGroup
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply