Cannot create DataSource "IDM_DataSource" Caused by: com.sap.sql.log.OpenSQLException: Could not load class com.microsoft.sqlserver.jdbc.SQLServerDrive

[Former Member]

Hello-

I am trying to install IDM on NW 7.1 CE EHP1 which is NW 7.11 .

I tried different JDBC drivers according to note "639702" , the one supported for 7.11 is SQL JDBC 2.0 drivers . But none of them are working for me.

After adding the driver and creating the custom DataSource , I also tried to restart the system. But still the same error.

I tried different drivers like sqljdbc2, sqljdbc3 and sqljbbc4 (no luck)

I have attached the complete log in the attachments, can someone please suggest a resolution?

2.#2013 02 13 08:44:27:943#0-500#Error#com.sap.engine.services.deploy#

#BC-JAS-DPL#deploy#E62CAD24A30200A60000000C0058008C#3506550000000004#sap.com/tc~lm~itsam~ui~mainframe~wd#com.sap.engine.services.deploy#Administrator#1##DBA00A6575DA11E2ADA2000000358176#dfc649c475e011e282d2000000358176#dfc649c475e011e282d2000000358176#0#startApp#Plain##

[ERROR CODE DPL.DS.6193] Error while ; nested exception is:

        com.sap.engine.services.deploy.exceptions.ServerDeploymentException: [ERROR CODE DPL.DS.5030] Clusterwide exception: [server ID 3506550:com.sap.engine.services.dbpool.exceptions.BaseDeploymentException: Cannot create DataSource "IDM_DataSource".

aused by: com.sap.engine.frame.core.database.DatabaseException: Exception of type com.sap.sql.log.OpenSQLException occurred: Could not load class com.microsoft.sqlserver.jdbc.SQLServerDriver with class loader library:MSSQL2010@com.sap.engine.boot.loader.ResourceMultiParentClassLoader@3daca240@alive..

        at com.sap.engine.core.database.impl.DataSourceAdministratorImpl.createDataSource(DataSourceAdministratorImpl.java:49)

        at com.sap.engine.services.dbpool.deploy.ContainerImpl.startDataSources(ContainerImpl.java:1473)

        ... 15 more

Caused by: com.sap.sql.log.OpenSQLException: Could not load class com.microsoft.sqlserver.jdbc.SQLServerDriver with class loader library:MSSQL2010@com.sap.engine.boot.loader.ResourceMultiParentClassLoader@3daca240@alive.

        at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:104)

Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

------------------------- Loader Info -------------------------

ClassLoader name: [library:MSSQL2010]

Living status: alive

Direct parent loaders:

   [system:Frame]

Resources:

   /usr/sap/CLD/J00/j2ee/cluster/bin/ext/MSSQL2010/SQLJDBC2.zip

---------------------------------------------------------------

        at com.sap.engine.boot.loader.MultiParentClassLoader.loadClass(MultiParentClassLoader.java:274)

        at com.sap.engine.boot.loader.MultiParentClassLoader.loadClass(MultiParentClassLoader.java:243)

        at com.sap.sql.connect.factory.VendorConnectionFactory.createInstance(VendorConnectionFactory.java:206)

        ... 23 mo

Thanks,

Siri

IDMError.txt.zip

[Former Member]

Which JDBC driver you need depends on which version of Java you are using and which version of Microsoft SQL Server you are running. All information required to successful installation is available from installation guide for IDM.

Regards,

Roman