I am unable to login to a SQL Server Express 2005 named instance on my server remotely. I get the error message "Login failed for 'USERNAME'" in SSMS. I have used the Surface Area tool to enable remote TCP connections (I've also tried Named Pipes).
In the ERRORLOG, I get 'Error: 18456, Severity: 14, State: 8'. According to http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx
, State 8 means 'mismatched password' but I absolutely know this is not the case, as I can login to the local SSMS using the same credentials.
Also, if I try a test from the Administrative Tools >> Data Sources (ODBC) window, the test comes back successfully.
Can anyone help?