November 7, 2007 at 9:55 am
Off late, some of my users get failed login:
login failed for user null/legit user. Not associated with trusted sqlserver connection.
Not sure why. This sql 2000 sp4 on win2k+3.
Nothing has changed.
Any advise.
The above message comes in sql logs.
November 7, 2007 at 10:28 am
Sounds like the users are part of a windows group. Check in Active directory if the group has been removed.
[font="Verdana"]Markus Bohse[/font]
November 7, 2007 at 12:09 pm
The AD group is still there and the user is added separately. The user re-booted his PC and it worked!. Not sure why this happened.
November 7, 2007 at 2:56 pm
The users could be leaving their PC's logged in but locked for more than 12 hours, therefor the Kerberos ticket is expiring, and SQL Server will no longer recognize the validity of the logged in user. When they rebooted their PC, they had to log back in to AD, thus getting a new ticket from Kerberos. If you get another instance of this, try to have the user log out of their machine and then log back in, I will bet that they don't really need to reboot.
HTH
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply