Token-based server access validation failed
I’ve been getting login errors, when I try and connect to a SQL instance from the localhost its installed on, but when I’m on a different server I could connect.. If you look at the Error log you see:
I did the normal and ran sp_srvpermissions and couldn’t see any denies set to my login or group. I then checked if anyone had created some silly login triggers but nothing!
The solution is UAC! close SSMS and open again with Admin privileges and you are good to go!