cancel
Showing results for 
Search instead for 
Did you mean: 

Error in establishing connection to SQL server

Former Member
0 Kudos

Hi All,

I am working on SQL->Sender JDBC->XI----->Reciever RFC -


> SAP scenario.

I have completed the configuration of the scenario.

The sql server is mySQL 2000.

Hence, in the sender JDBC adapter, i have given the following details.

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

Connection: jdbc:microsoft:sqlserver://<HOST>:<PORT>[;DatabaseName=<DB>]

my connection: jdbc:microsoft:sqlserver://172.20.20.76:1143[;DatabaseName=SEPG_NEWDB]

In Runtime Workbench->Component Monitoring>Adapter Engine--->Communication Channel Monitoring..

I am facing error as follows.....

Error during database connection to the database URL 'jdbc:microsoft:sqlserver://172.20.20.76:1433[;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://172.20.20.76:1433[;DatabaseName=SEPG_NEWDB]': SAPClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver'

What might be the reason behind this error....??????

Kindly help me.....

Regards

Pavan

Accepted Solutions (1)

Accepted Solutions (1)

nisarkhan_n
Active Contributor
0 Kudos

what's is the driver which you have deployed for this database?

Former Member
0 Kudos

Hi Khan,

The Driver for mySQL 2000 server is as follows....

com.microsoft.jdbc.sqlserver.SQLServerDriver

And the connection syntax which i have entered is as follows...

jdbc:microsoft:sqlserver://172.20.20.76:1433[;databaseName=SEPG_NEWDB]

Regards

Pavan

nisarkhan_n
Active Contributor
0 Kudos

what i meant was have you deployed the proper jar file(driver file) in the .sda file in using SDM......your driver parameter is fine just check this below

download the jdbc driver from url http://download.softagency.net/MySQL/Downloads/Connector-J/

(mysql-connector-java-3.1.14-bin.jar if you are using mysql 4.0)

the your parameter in Dapter

DBC driver: com.microsoft.jdbc.sqlserver.sqlserverdriver

connection: jdbc:microsoft:sqlserver://ip:port;databasename

also check this

tther option is download JDBC Driver from Microsoft Website

http://www.microsoft.com/downloads/details.aspx?FamilyID=6D483869-816A-44CB-9787-A866235EFC7C&displa...

and deploy the JDBC driver using SDM.

JDBC Driver Deployment Guide...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5dad2df...

how to configure drivers:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

also http://www.oracle.com/technology/software/tech/windows/odbc/index.html

Former Member
0 Kudos

Hi All,

I am working on mysql 2000 ->JDBC>XI> RFC--->SAP scenario.

The deployed Driver (found in Control Panel-->Administrative Tools) is as follows...

SQL Server

Version: 2000.85.1117.00

In XI-->JDBC sender, i have entered the Driver as com.microsoft.jdbc.sqlserver.sqlserverDriver

The Connection is as follows...

dbc:microsoft:sqlserver://172.20.20.76:1433[;DatabaseName=SEPG_NEWDB]

I am able to ping the SQL server through command Prompt.

But in XI>Runtime Workbench->Communcication Monitoring, I am getting an error for sender JDBC adapter as folllows.....

Error during database connection to the database URL 'jdbc:microsoft:sqlserver://172.20.20.76:1433[;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://172.20.20.76:1433[;DatabaseName=SEPG_NEWDB]': SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL.'

Now what to do in order to get the connection to SQL server through XI.....????

Please help me, if i am wrong in definging connection path for sender JDBC adapter......

Regards

Pavan

nisarkhan_n
Active Contributor
0 Kudos

you parameter shouls looks like

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

Connection: jdbc:microsoft:sqlserver://10.94.22.99:1433;DatabaseName=COS

your parameter are

com.microsoft.jdbc.sqlserver.sqlserverDriver

dbc:microsoft:sqlserver://172.20.20.76:1433[;DatabaseName=SEPG_NEWDB]

Confirm wether have you deloped these driver in the SDA file?sqljdbc.jar (for UNIX)

msbase.jar

mssqlserver.jar

msutil.jar

ojdbc14.jar

cross check your connection parameters with tha above one

Former Member
0 Kudos

Hi

Did you try connecting to the DB using some other tool like SQL Studio.Here you will come to know the exact Connection Parameters.

Thanks

Former Member
0 Kudos

Hi

Now are you able to connect??

Thanks

Former Member
0 Kudos

I am able to connect Monika...

Thanks for your help/concern....

Kindly help me on the other Qn related to an error at sender JDBC adapter level....

Please Help.......

Regards

Pavan

Former Member
0 Kudos

Hi

Also write down the Url and JDBC Driver, so that it can be of help to others also.

Thanks

Former Member
0 Kudos

hi,

can you please give the details of URL and Driver which you have used in solving this issue ASAP...

Thanks,

Prakash

Former Member
0 Kudos

Hi Prakash,

I have used the server name instead of IP and port.

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

The driver used is as follows...

<b>com.microsoft.jdbc.sqlserver.SQLServerDriver</b>

Regards

Pavan

Former Member
0 Kudos

hi ,

i am getting this error when trying to connect to SQL driver(2000),

'jdbc:microsoft:sqlserver://192.168.100.146:1433;DatabaseName=haier_office' failed: com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:microsoft:sqlserver://192.168.100.146:1433;DatabaseName=haier_office': ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver

can any one tell me why is it happening like this?

Former Member
0 Kudos

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

Connection: jdbc:microsoft:sqlserver://172.20.20.76\MIS_DEV_SVR;DatabaseName=sepg_newdb

With the above parameters, i have establilshed connection between XI and SQL server.

Regards

Pavan

Answers (1)

Answers (1)

Former Member
0 Kudos

As per ur first post, the connection string should be <b>d</b>atabaseName instead of

<b>D</b>atabaseName.

Regards,

Shabari

Former Member
0 Kudos

Shabari,

I have changed the Database to database in the connection paramaeter.

Still same error exists...

Any idea...???

Regards

Pavan