Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OBIEE JDBC connection to named Microsoft Sql Server 2005 Connection string

663702Oct 8 2008

Hi All

I am working on configuring the BI Publisher to talk with our SQL Server 2005 database.
Our database server has an instance name. server is io-consulting.us and the instance name is IOCORP

In the Scheduler when I test the connection

using the following connection string

jdbc:hyperion:sqlserver://io-consulting.us\IOCORP:1433;DatabaseName=OBIPUB

I get an success but with a warning about the URL not matching the protocol.

When I try to install the Schema it say it can not connect to io-consulting.usIOCORP

When I try to create a JDBC connection to a database to create reports agains I am not able to get any connection with our without the instance name.

Any suggesstions would be appreciated.
Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 5 2008

Added on Oct 8 2008

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

0 comments

300 views