I faced a very obnoxious situation today while connecting to sql server. The situation is as follows:
SQLServerA is installed on machine MachineA and SQLServerB is installed on machine MachineB. Both are sql server 2005. I am admin of both of these machines. My Login is not added in Security of SQLServerA.
The problem is that I can login to the SQLServerA from MachineB without any hindrance but when I try to connect to SQLServerA locally (From MachineA) then this throws eventid 18456.
I resolved this adding my login in the security of SQLServerA as a public user. But my question remains same. Why this allowed remote connection whereas local connection failed?
Lk