Skip to Content

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

Deploying asp.net 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;
            table.ApplyLogOnInfo(LInfo);
        }
    }

- 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?

Thanks

replied

HI,

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

Regards,

AG.

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