Unable to connect Mssql2008 server

[Former Member]

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

[rajasekhar_reddy14]

refer below thread.. yoour problem will get solved.

Regards,

Raj

[former_member188883]

Hi,

Could you look into SAP note 1093249 and check whether it helps.

Regards,

Deepak Kori

[Former Member]

Hi .

For Sql 2008 try with these values on CC Parameters:

JDBC Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver.
Connection : jdbc:sqlserver://"XXXXXXX:xxx";database="yourDatabase"

Regards

Luis