May 2, 2012 at 12:34 pm
One of our SQL servers has started rejecting our SQL statements from SQL Server Management Studio, if not on the server, giving "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."
When I connect the Studio is set to windows login.. and my login is NOT the above... so why am I having this issue when I am not on the server's Management Studio? (all my other servers are just fine, and I could swear this just started in the last 30 days or so.. but not sure)
May 2, 2012 at 12:52 pm
That error message almost always means you're trying to pass Windows credentials more than one "hop". Search online for "Kerberos double-hop" and you'll find the details on what that means and what to do about it. Lots of material available for that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 3, 2012 at 6:50 am
Thanks.. not sure why it is going more than one hop.. but will do.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply