Cannot establish connection - JDBC driver for MS SQL server 2000

[Former Member]

Hi,

We are facing problems in connecting to SQL server 2000.

We have installed the latest version of the driver from followin link and following

https://websmp108.sap-ag.de/msplatforms > SQL Server > JDBC Driver for MS SQL Server (Version 3.70.10)

We have given the following entries in our communication channel:

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

Connection: jdbc:sqlserver://<SQLserver IP>:1433;databaseName=production_info

Please let us know the procedure to find if the JDBC driver for SQL 2000 is installed from our SAP XI.

ERROR DETAILS:

Error during database connection to the database URL 'jdbc:sqlserver://<SQLserverIP>:1433;databaseName=production_info' using the JDBC driver 'com.microsoft.sqlserver.jdbc.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://<SQLserverIP>:1433;databaseName=production_info': SAPClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver'

Please help.

Regards,

Rehan

[Former Member]

It looks like you're using a 2K5 classname, I think for 2K it should be sthg like "com.microsoft.jdbc.sqlserver.SQLServerDriver"

Rgds

Chris

[Former Member]

Hi Chris,

We have used the same because we have downloaded the driver from following location

https://websmp108.sap-ag.de/msplatforms ; > SQL Server > JDBC Driver for MS SQL Server (Version 3.70.10)

I have tried with both "com.microsoft.jdbc.sqlserver.SQLServerDriver"; and "com.microsoft.sqlserver.jdbc.SQLServerDriver";, but still I am facing the same error.

Service market place has given the driver as "JDBC Driver for MS SQL Server (Version 3.70.10)", is there a way to find out if it is for 2000 or 2005?

Thanks for your reply.

Regards,

Rehan

[Former Member]

Rehan,

Did you deploy the MSSQL driver as explained by SAP (there is a PDF describing this somewhere on sapnet) ? I can't remember all the details, but this may be the first thing to check (after the successful deployment, you shoud be able to find the corresponding JAR files in one of the XI sub-directories) ...

Rgds

Chris

[Former Member]

Hi Rehan,

The SQL Server driver is not installed in your XI server. this is the only reason for this error. Please get the driver installed/deployed in your XI Server and it will start working fine.

You need to use driver name as com.microsoft.sqlserver.jdbc.SQLServerDriver only.

Thanks

Amit

[Former Member]

Hi,

We have installed the lastest driver and still we are facing the same problem.

We used following SAP note for installing the driver

Note 639702 - JDBC Driver for Microsoft SQL Server

Can anyone please help.

Error during database connection to the database URL 'jdbc:microsoft:sqlserver://100.100.5.118:1433;databaseName=production_info' using the JDBC driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:microsoft:sqlserver://100.100.5.118:1433;databaseName=production_info': SAPClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver'

Regards,

rehan

[Former Member]

hi

check the thread with same issue

/thread/48126 [original link is broken]

regards

kummari