MII 12.0 data connection to SQL 2008 R2

[Former Member]

We have deployed sqljdbc.jar

Connector = IDBC

Connector Type = SQL

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

Server Package = com.sap.xmii.Illuminator.connectors.IDBC

Server URL = jdbc:sqlserver://<SERVER>:1433;database=<DATABASE>

UserName = <USER>

PWD = <PWD>

I am not getting an error, but I am seeing that the database says STOPPED. I checked with the dba and he said the database is up and running just fine.

I have checked some other posts in this forum and most have to do with receiving an error when they check the status. Like I said, I am not getting an error just that the database is STOPPED.

Thanks in advance.

[Former Member]

Chip,

I had the same issue a while ago and after deploying "sqljdbc4.jar" things started working fine. Also make sure that the database you are trying to connect has the required authorization.

Regards,Tony.

[Former Member]

See if my old thread helps:

[|]

[Former Member]

Hi Chip,

A couple of things I've picked up along the way connecting to databases:

A status of "Stopped" could indicate

1. The Data Server was not "Enabled"

2. The wrong jdbc driver was used.

I have had problems connecting with the 3.0 sqljdbc.jar driver and went back to the version 2 sqljdbc.jar driver.

Also, you can check for messages in the Netweaver logs.

Warm Regards,

Diana Hoppe

[Former Member]

Here are the logs...

warning 2011-08-25 11:02:33:366 *** MISSING RESOURCE: Unable to localize DRIVER_FILE_REQUIRED

/Applications/LHCommon com.sap.lhcommon.localization.MessageCatalog sap.com/xapps_xmiiear DUSLEXXMD01 Server 0 10_29716

warning 2011-08-25 11:02:33:272 Unable to scan file sqljdbc.jar: com.sap.security.core.server.vsi.api.exception.VSIServiceException: No default virus scan profile available.

/Applications/XMII com.sap.xmii.Illuminator.util.VirusChecker sap.com/xapps_xmiiear DUSLEXXMD01 Server 0 10_29716

warning 2011-08-25 11:02:33:272 Unexpected Exception

/Applications/XMII com.sap.xmii.Illuminator.util.VirusScanner sap.com/xapps_xmiiear DUSLEXXMD01 Server 0 10_29716

warning 2011-08-25 11:02:17:991 *** MISSING RESOURCE: Unable to localize DRIVER_FILE_REQUIRED

/Applications/LHCommon com.sap.lhcommon.localization.MessageCatalog sap.com/xapps_xmiiear DUSLEXXMD01 Server 0 10_29716

We are doing this off site via VPN. I am wondering if this is a remote access issue, rights issue or something else.

[Former Member]

Chip,

Probably a long shot, but the only other thing I can think of is when attempting to upload and deploy a jdbc driver the file will first need to be saved into the \windows\temp directory on the xMII machine, and your user would need the appropriate rights on the machine to do this.

I also recall some problem when using JDK 1.4.2_18 on the client machine.

- Diana

[Former Member]

Chip, I think that is the same error I got when I was having trouble. I would double check that the driver you are trying to use is compatible with the JRE/JDK version Netweaver is using.