Skip to Content
0
Former Member
Aug 18, 2008 at 10:38 AM

Cannot establish connection - JDBC driver for MS SQL server 2000

363 Views

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