Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Deploying project / access failed in reportviewer

Hi. I'm not able to display the report..

I'm preparing the production server:

. i've installed s.o. = Windows Server 2003 with all patches

. i've added the application role (II6)

. i've installed last runtime for Crystal Report 2008 and .net = CRRuntime_12_1_mlb.msi

. i've deployed my aaplication on the default web site

Result: the site's pages works fine except for displaying my reports! In the position of the report appears a message (in italian: Accesso al database non riuscito) like database access failed..

I don't understand the cause:

- i'm using the same sources working fine on 2 other environment machine (Vista SP1 and another Windows Server 2003)

- the user for database login is written in code, like the Microsoft practices:

private void SetDBLogonForReport()
        ConnectionInfo conn = new ConnectionInfo();
        //conn.Type = ConnectionInfoType.SQL;
        conn.ServerName = "name_server";
        conn.DatabaseName = "name_db";
        conn.UserID = "user";  
        conn.Password = "pwd"; 

        TableLogOnInfo LInfo = new TableLogOnInfo();

        foreach (CrystalDecisions.CrystalReports.Engine.Table table in myReport.Database.Tables)
            LInfo = table.LogOnInfo;
            LInfo.ConnectionInfo = conn;

- the app don't cause exceptions (i've run it in debug mode directly on the server without problems

Maybe the message is misleading and the cause is not about db?




Ya, I know that we needed the SQL Client. I just mentioned that because I though this might help you too.



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question