I am trying to login to SQL server 2005, and it gives me an error 18456..
This is very funny...I go to advanced option and set network protocol as TCP/IP it does not work..if I leave it as default it works....
I remember we user TCP/IP authentication....why is this an issue ?