Skip to Content
0
Former Member
Nov 25, 2011 at 12:23 PM

Unable to connect Mssql2008 server

22 Views

Hi Friends,

I am working on SAP PI7.0. We are sending data from sap to SQL Server2008 database.I am getting following error in JDBC channel.

''Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://IPADDRESS:1433;Database=XXXX;': com.microsoft.sqlserver.jdbc.SQLServerException: The server version is not supported. The target server must be SQL Server 2000 or later''

After we getting error,we have instaled MSSQL2005 version drivers downloaded from service market place.Again i am reciving new error.

Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://XXXXX;user=sa;password=XXX;Database=EmployeeMaster;': UnsupportedClassVersionError: com/microsoft/sqlserver/jdbc/SQLServerDriver (Unsupported major.minor version 50.0)

Please help me.

Thanks

Ravi

Edited by: ravi aalla on Nov 25, 2011 1:33 PM