Showing results for 
Search instead for 
Did you mean: 

Crystal Report Oracle Logon Problem

Former Member
0 Kudos


We are using Webforms for launching the reports. When we tried to launch the reports system is prompting for logon information. It states "The report you requested requires further information." followed by text box having Server Name, Database Name, User Name, Password and use integrated security(checkbox).

We are using Oracle backend for connecting the database. Crystal Report RPT is designed using the OLEDB ADO (Database Type) and the provider is u201CMSDAORAu201D.

The same report is working fine when the Internet service manager identity is set as u201CLocal Systemu201D reported problem occurs when the identity is set as u201CNetwork Serviceu201D. How to over come this issue.

Crystal Version : Crystal Reports 2008 is installed

Operating System : Windows server 2003 standard edition

Oracle Version : Oracle 11g

Please Note : Report is fetching data from the crystal report designer in the preview. There is no problem in oracle connectivity.

Code is available below


CrystalDecisions.CrystalReports.Engine.Database crDb;

CrystalDecisions.CrystalReports.Engine.Tables crTables;

CrystalDecisions.CrystalReports.Engine.Table crTable;

TableLogOnInfo crTableLogOnInfo;

ConnectionInfo crConnInfo;

crDb = rpt.Database;

crTables = crDb.Tables;

crConnInfo = new CrystalDecisions.Shared.ConnectionInfo();

crConnInfo.ServerName = "< Oracle Service Name>";

crConnInfo.DatabaseName = "";

crConnInfo.UserID = "<Oralce User Name>";

crConnInfo.Password = "<Oracle Password>";

for (int i = 0; i < crTables.Count; i++)


crTable = crTables<i>;

crTableLogOnInfo = crTable.LogOnInfo;

crTableLogOnInfo.ConnectionInfo = crConnInfo;



CrViewer.ReportSource = rpt;

Accepted Solutions (1)

Accepted Solutions (1)

Active Contributor
0 Kudos

If Local System works and Network Service does not, you're looking at permissions. E.g.; nothing really to do with CR. [Process Monitor|] may help you there.

Logging the DB calls may help also.

Search the forums for how to. See Kb [1553469 - How to enable Database logging in Crystal Reports for Visual Studio 2010|] [original link is broken]; - you'll have to adjust for CR2008.


Follow us on Twitter

Got Enhancement ideas? Try the [SAP Idea Place|]

Answers (0)