Reporting services giving a 500 internal server error?

Discussion in 'ASP.NET 2.0' started by johnsmith, Feb 10, 2009.

  1. The report is uploaded and everything seems to be correct,
    however i keep getting a 500 internal server error without any explanations of the problem. What can see problem be? I'm using the correct credentials.
    thanks!
    here is my code:


    reports.aspx:
    <rsweb:ReportViewer ID='ReportViewer1' runat='server' Font-Names='Verdana'
    Font-Size='8pt' Height='400px' Width='400px' ProcessingMode='Remote' >
    <ServerReport ReportServerUrl='https://rs2k501.discountasp.net/ReportServer' ReportPath='/dustinrosen/reports/report3' DisplayName='MyReport' />
    </rsweb:ReportViewer>


    reports.aspx.cs:

    protected void Page_Init(object sender, EventArgs e)
    {
    if (!Page.IsPostBack)
    {

    DataSourceCredentials cred = new DataSourceCredentials();
    cred.Name = 'booksConnectionString';
    cred.UserId = 'rs_******';
    cred.Password = '34********';


    ReportViewer1.ServerReport.SetDataSourceCredentials(new DataSourceCredentials[] { cred });
    ReportViewer1.ServerReport.Refresh();
    ......


    report3.rdlc:


    <Report xmlns='http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition' xmlns:rd='http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'>
    <DataSources>
    <DataSource Name='booksConnectionString'>
    <rd:DataSourceID>ec8db75f-da62-4050-9787-f28c1a48f5c8</rd:DataSourceID>
    <ConnectionProperties>
    <DataProvider>SQL</DataProvider>
    <ConnectString>
    </ConnectString>
    </ConnectionProperties>
    </DataSource>
    </DataSources>
    <rd:ReportID>aa0f6392-a934-473b-be73-f3979d9b69e0</rd:ReportID>
    <Width>5in</Width>

    <Height>2.45in</Height>
    <ColumnSpacing>0.5in</ColumnSpacing>
    <ReportItems>
    <Textbox Name='textbox1'>
    <Style>
    .....
     
  2. Bruce

    Bruce DiscountASP.NET Staff

  3. i tried to disable the friendly error but it just shows an empty screen anyway.
    Is there any log file anywhere?
     
  4. Bruce

    Bruce DiscountASP.NET Staff

  5. Bruce

    Bruce DiscountASP.NET Staff

  6. Bruce

    Bruce DiscountASP.NET Staff

Share This Page