Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Error in configuring JDBC Adapter

Hi All,

I have configured a sender JDBC Adapter with the following parameters.

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

Connection: jdbc:microsoft:sqlserver://MIS-SERVER\MIS_DEV_SVR;DatabaseName=SEPG_NEWDB

But in Runtime, I am getting error as follows...

Error during database connection to the database URL 'jdbc:microsoft:sqlserver://MIS-SERVER\MIS_DEV_SVR;DatabaseName=SEPG_NEWDB' using the JDBC driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:microsoft:sqlserver://MIS-SERVER\MIS_DEV_SVR;DatabaseName=SEPG_NEWDB': SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]The requested instance is either invalid or not running.'

It has been confirmed that JDBC Drivers are properly deployed.

Any suggestions to resolve this issue?

Regards

Pavan

Former Member
Former Member replied

Hi

Check whether you are using the same format

JDBC Driver :

jdbc:microsoft:sqlserver://<server name>[;DatabaseName=SEPG_NEWDB]

Connection:

com.microsoft.jdbc.sqlserver.SQLServerDriver

Thanks

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question