Skip to Main Content

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!

BI Publisher - could not establish connection

601520Oct 9 2007 — edited Apr 7 2011
I have installed Oracle BI EE and I am trying to configure BI Publisher. In admin > System Maintenance > Scheduler configuration I have entered the following for a SQL Server database:
Database Type - Microsoft SQL Server
Connection String - jdbc:sqlserver://<server name>
username - oraclebi
password - password
Database Driver Class - com.microsoft.jdbc.sqlserver.SQLServerDriver

oraclebi is the user I have created in SQL Server to access the database I created. I am signed in as Administrator, and used cryptotools to add alias of bipublisheradmin to credentialstore.xml.

When I select Test Connection I get the error - could not establish connection.

Does any jdbc software have to be installed or should I be using that installed with BI EE, in which case what are the connect string and driver class? Anything else I may have missed.
Many thanks
Bob Pentney
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details