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!