Skip to Content
avatar image
Former Member

MII 12.0 data connection to SQL 2008 R2

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Aug 25, 2011 at 01:58 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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.

  • avatar image
    Former Member
    Aug 25, 2011 at 02:05 PM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 30, 2011 at 11:15 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded