Microsoft SQL Server 2005 is not compatible with versions of WebSphere Application Server prior to version 6.1

Answer

WebSphere Application Server versions prior to V6.1 were written to be compatible with the Microsoft SQL Server 2000 database. However, Microsoft SQL Server 2005 is not fully forward compatible from Microsoft SQL Server 2000, and therefore WebSphere Application Server versions prior to V6.1 are not fully compatible with Microsoft SQL Server 2005.

The Application Server uses SQL syntax for table lock hints that is valid on Microsoft SQL Server 2000, but no longer valid in Microsoft SQL Server 2005. This affects generated code for CMP, the Scheduler, and applications that specify table lock hints directly.

Additionally, the JDBC driver shipped with the Application Server prior to V6.0.2.25 and V5.1.1.17 is not capable of connectivity to the Microsoft SQL Server 2005 database.

In order to minimize these incompatibilities, customers who use the Microsoft SQL Server 2005 database with WebSphere Application Server versions prior to V6.1 should move to V6.0.2.25+ or V5.1.1.17+ and run in SQL Server 2000 compatibility mode.

--------------------------------------------------------
Disclaimer: The information in this IBM Technote is believed to be accurate at the time of publishing based on currently available information. Information in this document may change at any time at IBM’s sole discretion based on market opportunities or other factors, and are not intended to be a commitment to future products, feature availability, or support in any way. IBM is not responsible for the misuse of the information provided in this Technote and use of the information constitutes acceptance for use on an AS IS basis and at the user's risk. There are no warranties with regard to this information. Neither the author nor the publisher accepts any liability for any direct, indirect, or consequential loss or damage arising from use of, or reliance on, this information.