cancel
Showing results for 
Search instead for 
Did you mean: 

ActivePortals Database

Former Member
0 Kudos

I downloaded the ActiveMetrics Sample application for MII 12.0. I am unable to connect to the ActivePortals SQL db provided.

I see a message in the Log about having to add additional permissions in the SLD. I have Admin rights.

Has anyone faced a similar problem ?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

thanks

Former Member
0 Kudos

I am unable to connect to the ActivePortals SQL db provided.

I thought the only thing provided with the download was the script that you run against a database that you create and name it ActivePortal.

I cannnot comment from an SLD point of view but when you say unable to connect can you detail out -

1. Whether the data server ActivePortal is properly configured and running?

2.If yes then are you able to run any queries against it from MII?

Former Member
0 Kudos

Hi,

Here are my Db settings. Please can you let me know if anything here needs to be corrected.

Connector IDBC

ConnectorID

ConnectorType SQL

DatePrefix '

DateSuffix '

DaysRetention 7

Description Active Portal Database

Enabled T

InitCommand

InternalDateFormat yyyy-MM-dd HH:mm:ss

JDBCDriver com.inet.tds.TdsDriver

MaxRetryCount 5

Name ActivePortal

PoolMax 100

PoolSize 1

RetryInterval 60000

ServerPackage com.sap.xmii.Illuminator.connectors.IDBC

ServerURL jdbc:inetdae:etcstucd403:1433?database=ActivePortal&SQL2005=true

Timeout 15

UseCount 256

UserName xmii

ValidationQuery SELECT GETDATE()

WaitTime 30

Former Member
0 Kudos

Looks good except for the JDBC driver.

This is SQL 2005 right? And you must've uploaded sqljdbc.jar as the JDBC driver.

You probably need to do a search here in the forums for the correct JDBC driver configuration value.

Meanwhile if I find it I'll post it.

Former Member
0 Kudos

I have uploaded the SQLJdbc.jar

Former Member
0 Kudos

Use

com.microsoft.sqlserver.jdbc.SQLServerDriver

instead of

com.inet.tds.TdsDriver

for the JDBC Driver parameter value

I am sure this'll fix it.

Former Member
0 Kudos

JDBCDriver com.microsoft.sqlserver.jdbc.SQLServerDriver

ServerURL jdbc:inetdae:etcstucd403:1433?database=ActivePortal&SQL2005=true

it still does not seem to be wrking ...

I tried changing the ServerURL to be sqlserver instead of inetdae, as well

Former Member
0 Kudos

Check in the Netweaver Logs for errors referring to this dataserver.

Also verify---

1. Authentication

2. Does your SQL server allowing TCP/IP requests on port 1433 or is it a different port?You DBA guy can help you with this.

Also for the ServerURL jdbc:inetdae:etcstucd403:1433?database=ActivePortal&SQL2005=true

instead try a

jdbc:inetdae:etcstucd403:1433?database=ActivePortal&sql7=true