cancel
Showing results for 
Search instead for 
Did you mean: 

unable to connect SQL2008 system

abhay_aggarwal
Participant
0 Kudos

Dear All,

I am trying to connect to SQL database 2008 system at receiver side.

for this I have used Business Service and configured the JDBC adapter at receiver side.

Do I need to make configured Busniess System in SLD?

I am using

JDBC Driver: com.sap.nwmss.jdbc.sqlserver.SQLServerDriver

and

connection string=jdbc:nwmss:sqlserver://iltlvsap99:1433;DatabaseName=BPV

is the correct parameter ?

when I am testing this scenario

I am getting below error in RWB

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: JDBC Adapter configuration not initialized: null

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:nwmss:sqlserver://iltlvsap99:1433;DatabaseName=BPV': SAPClassNotFoundException: com.sap.nwmss.jdbc.sqlserver.SQLServerDriver

Please advice.

Regards

Accepted Solutions (0)

Answers (2)

Answers (2)

madhusudana_reddy2
Contributor
0 Kudos

You Driver class is wrong use below format

com.microsoft.sqlserver.jdbc.SQLServerDriver

jdbc:sqlserver://xxx.xx.xxx.xxx;DatabaseName=mydbname

thanks,

madhu

sunilchandra007
Active Contributor
0 Kudos

Hi Abhay,

Check Raja's reply in . Your connection parameter doesn't seem correct. If it doesn't work even after correcting the parameters, then check if the sql driver is properly installed or not.

Regards,

Sunil Chandra