Sql server 2005 and 2008 express compatibility issues

Question

Hi,

Client Side (SQL Server 2005): "Login failed for user... (Microsoft SQL Server, Error: 18456), when trying to connect to a network server.

Server Side (SQL Server 2008): Had already checked all possible connection issues that might causing the error. Network, remote, browser, port, firewall, SSMS settings, and even read articles for error messages. Had configured the server authentication setting to Windows Authentication Mode thinking it might be the simplest way to connect, but still won't work.

Have both machines using MS Windows XP Professional version 2002 with SP2 and just differs on versions of SQL (2005 vs 2008).

Looking forward for any idea. I might be missing compatibility issues here as well.



Thanks in advance,

phoebe_gwen

Answer 1

The error 18456 is generic login failure message and you need to know the exact state of this error.
You can get the state number from errorlog file and i have an article on issues pertaining to login failed error 18456 - http://sql-articles.com/articles/troubleshooting/troubleshooting-login-failed-error-18456 .

---

Thanks, Leks