MII Data Servers

[Former Member]

Hi,

I defined data server for Ms-SQL 2005.

When i pressed status button it gets status --> pending information.

Data Server parameters for sql-2005

JDBCDriver --> com.microsoft.sqlserver.jdbc.SQLServerDriver

ServerURL --> jdbc:sqlserver://NTBSRV\SQLEXPRESS2005:1433;databaseName=MII_tst

I used sqljdbc.jar version 1.2 for MsSQL 2005

How can i solve this problem?

Thanks

[jamie_cawley · Accepted solution]

Check out note 990322

[https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=990322]

Jamie

Edited by: Jamie Cawley on Apr 6, 2009 9:06 AM

[Former Member]

Hi Cemil,

Try giving like below

JDBCDriver --> com.microsoft.jdbc.sqlserver.SQLServerDriver

ServerURL --> jdbc:microsoft:sqlserver://NTBSRV\SQLEXPRESS2005:1433;databaseName=MII_tst

[Former Member]

Hi,

is it possible use sqlserver 2005 or sqlserver 2008 with MII?

Thanks.

[Former Member]

Cemil,

connection to MS SQL 2005 is possible with the [MS SQL JDBC Driver 1.2|http://www.microsoft.com/downloads/details.aspx?familyid=C47053EB-3B64-4794-950D-81E1EC91C1BA&displaylang=en]. You need to check

the Microsoft System Requirements and the NW System Requirements.

MS SQL 2008 required the JDBC Driver 2.0 from Microsoft. The Microsoft JDBC Driver 2.0 required the

JDK 5 and this version is not supported from the NW.

Maybe SAP can provide you a Driver.

Regards

Pedro

Edited by: Pedro Iglesias on Apr 5, 2009 2:54 PM

[Former Member]

Hi Cemil,

Have you set Id and password even?

[Former Member]

Hi Rao,

i found some information from log file below

#1.5 #001CC4D2920100A60000000000000E78000466CA9E28AC98#1238920329734#/Applications/XMII#sap.com/xapps_xmiiear#com.sap.xmii.Illuminator.tools.database.ConnectionPool#Guest#0##n/a##4117ca6021bc11de8bc1001cc4d29201#Thread[Thread-119,5,SAPEngine_Application_Thread[impl:3]_Group]##0#0#Warning#1#com.sap.xmii.Illuminator.tools.database.ConnectionPool#Plain###Unable to detemermine maximum number of connections from JDBC driver#

#1.5 #001CC4D2920100A60000000100000E78000466CA9F0E520C#1238920344781#/Applications/XMII#sap.com/xapps_xmiiear#com.sap.xmii.Illuminator.tools.database.ConnectionPool#Guest#0##n/a##4117ca6021bc11de8bc1001cc4d29201#Thread[Thread-119,5,SAPEngine_Application_Thread[impl:3]_Group]##0#0#Warning#1#/Applications/XMII#Plain###Unable to fill connection pool for jdbc:sqlserver://ntbsrv
SQLEXPRESS2005:1433;databaseName=MII_tst#

#1.5 #001CC4D2920100A60000000300000E78000466CA9F0E5561#1238920344781#/Applications/XMII#sap.com/xapps_xmiiear#com.sap.xmii.Illuminator.tools.database.ConnectionPool#Guest#0##n/a##4117ca6021bc11de8bc1001cc4d29201#Thread[Thread-119,5,SAPEngine_Application_Thread[impl:3]_Group]##0#0#Info#1#com.sap.xmii.Illuminator.tools.database.ConnectionPool#Plain###Created Connection pool [jdbc:sqlserver://ntbsrv
SQLEXPRESS2005:1433;databaseName=MII_tst]:

#

[abesh]

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