SAP XI Adapter JDBC "Error during database connection to the database"

[Former Member]

Hello Colleagues,

after setup an JDBC Adapter Communication Channel we receiving following error:

Error during database connection to the database URL 'jdbc:microsoft:sqlserver://<IP>:1433;databaseName=<SID>' using the JDBC driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:microsoft:sqlserver://<IP>:1433;databaseName=<SID>': SAPClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver'

Following configuration done at Communication Channel:

JDBC Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection: jdbc:microsoft:sqlserver://localhost:1433;databaseName=<DB>

Could somebody tell us the problem?

Many thanks in advanced!

Regards,

Jochen

[VijayKonam · Accepted solution]

Since it says, SAP class not found exception, it might be the case that, the JDBC driver has not been properly installed to communicate with the database. Please check if the JDBC driver for SQL Server was properly setup.

The procedure is:

1.Add all jars to the archive aii_af_jmsproviderlib.sda, modify the provider.xml file and WinZip the .sda file again.

a)Copy the file: aii_af_jmsproviderlib.sda from the path ..\usr\sap\SID\DVEBMGS00\SDM\root\origin\sap.com\com.sap.aii.af.jmsproviderlib\SAP AG\3.0.20040112154003.0000. to any other drive on the server.

b)Unzip it. After Unzipping the archive there are 2 folders created under the provided directory

\META-INF

\server

c) Edit the file provider.xml

Add the vendor specific jar file names to the provider.xml file in between the tags <jars> …</jars> and Save it.

For you it will be

<jars>

<jar-name>msbase.jar</jar-name>

<jar-name>mssqlserver.jar</jar-name>

<jar-name>msutil.jar</jar-name>

</jars>

d)Copy the specific driver files to the same dirctory where u have unzipped the .sda

e)Now ZIP the following files/folders from the drive/dirctory.

• Vendor driver files

• META-INF folder

• Server folder

The name of the zip file should be the same i.e aii_af_jmsproviderlib.sda

2.Deploy the archive aii_af_jmsproviderlib.sda on to the J2ee Engine using SDM tool.

This will solve ur problem.

Regards,

Vijay

[Former Member · Accepted solution]

Hello Vijay,

indeed the problem was related to an not installed SQL driver on the respective XI system. After deployment all looks fine.

Additional very helpfully documentations:

- SAP Note 831162

How-to Guides: http://www.sdn.sap.com/irj/sdn/howtoguides

- How To Install and Configure External Drivers for the JDBC & JMS Adapters

Many thanks (to all) for support!

Regards,

Jochen

[VijayKonam · Accepted solution]

good to see that I was helpful.

Vijay

[Former Member]

Jochen,

Its complaining about connecting to the Database. Instead of localhost try giving the IP address and check. Just make sure that the User ID and password are correct and that XI server has coonectivity to the Database.

Also if it dont work then try coonecting to another installation of the database in the same network and see if connectivity is available. Try a ping on the IP address and port on which the DB is running from your XI server and see if it works. Find out if all ports and firewall are open for the DB access from XI.

---Satish