SQL Server 2008 compatibility with SAP PI 7.0

[former_member185881]

Hi All

Scenario is like this:

XI is fetching data from SQL Server.

Previously we were using SQL Server 2005 and XI was successfully fetching data from it.

Communication channel setting:

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

Connection : jdbc:sqlserver://10.10.100.180;user=abc;password=xyz;database=CUSTOMER

Two days back SQL team uninstalled SQL Server 2005 and installed SQL Server 2008

After doing this XI stopped fetching data from SQL and error is "Error during database connection to the database URL 'jdbc:sqlserver://10.10.100.184;user=sqluser;password=india123;database=CUST_HO' using the JDBC driver 'com.microsoft.sqlserver.jdbc.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://10.10.100.184;user=sqluser;password=india123;database=CUST_HO': com.microsoft.sqlserver.jdbc.SQLServerException: The server version is not supported. The target server must be SQL Server 2000 or later."

Please help me how to solve this problem.

Regards

Dheeraj Kumar

[prateek · Accepted solution]

This looks like compatibility issue of SQL Server 2008 with your current JDK version. I think it will support JDK 5 which your current system may not have. See if you can get compatible drivers.

Regards,

Prateek

[former_member185881 · Accepted solution]

Hi Prateek

As far as i know if i will load JDK5 then netweaver will not work. i asked to basis person too he also told me the same thing.

We even tried to load another driver got from microsoft website - sqljdbc_2.0.1803.100_enu.exe

after updating this driver i got error - "Error during database connection to the database URL 'jdbc:sqlserver://10.10.100.184;user=sqluser;password=india123;database=CUST_HO' using the JDBC driver 'com.microsoft.sqlserver.jdbc.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://10.10.100.184;user=sqluser;password=india123;database=CUST_HO': UnsupportedClassVersionError: com/microsoft/sqlserver/jdbc/SQLServerDriver (Unsupported major.minor version 50.0)'"

Regards

Dheeraj kumar

[prateek · Accepted solution]

You can try this. Use SQL Server 2005 drivers to connect to SQL Server 2008 and see if it works.

Regards,

Prateek

[former_member185881 · Accepted solution]

Hi Prateek

I have already tried this but its not working.

Is PI 7.0 is comaptible to run on JDK5?????

Regards

Dheeraj kumar

[Former Member · Accepted solution]

Hi Dheeraj,

Please go through this link which is also having the same problem:

We are using PI7.01 with JRE version of 1.5.0_09 and sp 13. It's working fine. So, PI 7.01 is compatible with jre 1.5. So please update your JRE version and then install the SQL server 2008 driver. I hope it will be helpful.

Regards,

Nutan

Edited by: nutan champia on Mar 17, 2010 10:22 AM

[former_member185881]

Hi All

PLEASE REFER THIS BLOG CREATED BY ME AND YOUR PROBLEM WILL BE SOLVED.

/people/dheeraj.kumar5/blog/2010/03/23/sql-server-2008-connectivity-with-sap-pi-70-possile

REGARDS

DHEERAJ KUMAR

[Former Member]

Hi Deeraj,

I think this issue is realted to JDK version.now u r using JDK4 .So it is showing Error.Youneed to install JDK5.

Thanks

Ravi

[former_member181985]

You might have to deploy the JDBC2.0 drivers compatible with SQL 2008.

Check the official SQL vendor site.

Check this link:

[http://www.microsoft.com/downloads/details.aspx?FamilyID=99B21B65-E98F-4A61-B811-19912601FDC9&displaylang=en]

Edited by: Praveen Gujjeti on Mar 5, 2010 4:08 PM

[former_member185881]

Hi Praveen

As far as i know if i will load JDK5 then netweaver will not work. i asked to basis person too he also told me the same thing.

We even tried to load another driver got from microsoft website - sqljdbc_2.0.1803.100_enu.exe

after updating this driver i got error - "Error during database connection to the database URL 'jdbc:sqlserver://10.10.100.184;user=sqluser;password=india123;database=CUST_HO' using the JDBC driver 'com.microsoft.sqlserver.jdbc.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://10.10.100.184;user=sqluser;password=india123;database=CUST_HO': UnsupportedClassVersionError: com/microsoft/sqlserver/jdbc/SQLServerDriver (Unsupported major.minor version 50.0)'"

Regards

Dheeraj kumar