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:

LoginFailure

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!

Advertisements