on 07-23-2008 3:46 AM
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 ?
thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
8 | |
7 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.