Viewing Reports through the Report Manager

  • I have successfully installed the sql server reporting services on a windows 2003 server.  I have been able to deploy several reports to the report server.  I have even been able to schedule a report to execute and send out via email every morning of the week. 

    Here's the problem.  When I try to view a report using the report manager I get a

    The page cannot be found

    HTTP 404 - File not found

    Internet Explorer

    error.  I just don't get it.  I can perform every other function using the report manager except view the report online.  Which of course is a problem because I want to send my customers to the site to be able to view and run reports. 

    Thanks for any help.

  • I've never dealt with reporting services but I did find some info/links that you may be able to use to resolve your issue:

    from the microsoft site:

    1) "When you deploy a site in Windows Server 2003, you may receive the following error message:

    The remote server returned an error: (404) Not Found.

    This occurs because the ASP.NET account does not have permission to access the site deployment directory on Windows Server 2003. To grant the ASP.NET account access to the site deployment directory:

    1.Right-click Start, click Explore, and then locate installation directory\inetpub\.

    2.Right-click the Wwwroot folder, and then click Properties.

    3.In the Wwwroot Properties dialog box, click the Security tab, and then click Add.

    4.In the Select Users or Groups dialog box, click Locations, select the local computer, and then click OK.

    5.In the text box, type aspnet, and then click Check Names. This changes the text to computername\ASPNET.

    6.Click OK.

    7.In the Permissions for ASPNET Account box, make sure that the ASPNET account has the following permissions:

    •Read & Execute

    •List Folder Contents

    •Read"

    2)asp.net

    3) article







    **ASCII stupid question, get a stupid ANSI !!!**

  • I appreciate your assistance in this.  I have tried several different permissions "things".  The only thing that I didn't do in this case was to give the aspnet account access to the wwwroot folder.  But alas, still 404.  The sql server report services web folder isn't in the wwwroot but I thought I would give it a try.  I am confident that it is a permissions issue but am not sure where to go from here.  I read through the articles in the links that you sent.  The first link had someone giving the aspnet account local admin.  I tried that but, thankfully, it didn't work.  I wouldn't be comfortable with the aspnet account having admin.  I will keep plugging away.  Thanks.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply