2232201 - SAPClassNotFoundException while connecting to SQL Server 2008

You have prepared and deployed the "com.sap.aii.adapter.lib.sda" after adding all the JDBC driver jars in the lib directory and entering the line of driver jars in provider.xml as below:

<jars>
    <jar-name>lib/com.sap.aii.adapter.lib_api.jar</jar-name>
    <jar-name>lib/sqljdbc4.jar</jar-name>
    <jar-name>lib/sqljdbc.jar</jar-name>
</jars>

In JDBC channel, you have configured JDBC Driver and Connection information in Database connection part.

However, the JDBC adapter throws the following error while connecting to Microsoft SQL Server 2008 database:

=====
Cannot establish connection with the registered driver.
com.microsoft.jdbc.sqlserver.SQLServerDriver returns:
com.microsoft.jdbc.sqlserver.SQLServerDriver.
:SAPClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
====

• SAP NetWeaver 7.3
• SAP enhancement package 1 for SAP NetWeaver 7.3
• SAP NetWeaver 7.4

SQL Server 2008, JDBC Driver, SAPClassNotFoundException, Process Integration 7.30, PI 7.30, Process Integration 7.31, PI 7.31, Process Orchestration 7.4, PI 7.4, PO 7.4, XI, AEX , KBA , BC-XI-CON-JDB , JDBC Adapter , Problem