Sql server 2005 and 2008 express compatibility issues


  • 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,


    Wednesday, December 16, 2009 9:52 PM