MII query template does not connect to ms-sql server 2008

[Former Member]

Hi,

MII query template does not connect to ms-sql server 2008.

I deployed jdbc driver (sqljdbc4.jar)

Data Servers

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

Server URL -->jdbc:sqlserver://localhost\SQLEXPRESS:1433;databaseName=MII_tst

What must i do to connect MsSql 2008?

Thanks.

[abesh · Accepted solution]

I hope this solves your problem :

[xMII 12.0 : Connecting to a Microsoft SQL Server 2000|https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/8426] [original link is broken] [original link is broken] [original link is broken];

BR

Abesh

[Former Member · Accepted solution]

Cemil,

did you deploy the MS SQL JDBC Driver 2.0? Remember, that the JDBC Driver 2.0 required the JDK 5

that is not supported from SAP Netweaver. Only the JDBC Driver 2.0 supporting the MS SQL 2008.

You need to verify/check the Software Requirements from SAP Netweaver and MS JDBC.

Hope this will help you.

Regards

Pedro

[Former Member]

Any errors in the logs?

[Former Member]

Hi where can i see log?

Thanks.

[Former Member]

Hi,

i found knowledge below from log file

Unable to scan file sqljdbc.jar: com.sap.security.core.server.vsi.api.exception.VSIServiceException: No default virus scan profile available.#

#1.5 #001CC4D2920100560000002300000DC4000466BD635D9FF9#1238863508656#/Applications/LHCommon#sap.com/xapps_xmiiear#com.sap.lhcommon.localization.MessageCatalog#Administrator#72##n/a##1ca8aae0213611deb23e001cc4d29201#SAPEngine_Application_Thread[impl:3]_18##0#0#Warning#1#com.sap.lhcommon.localization.MessageCatalog#Plain###*** MISSING RESOURCE: Unable to localize DRIVER_FILE_REQUIRED#

Thanks