Sqlserver Report server's HTTP 500 Internal Server Error

  • Hi All,

    I am new to the SQL server Reporting services.We are using SQLServer 2008.We already configured the reporting server using reporting services configuration manager.But when we tried to open the report manager url(http://W01SALMAPP1A:80/Reports) we got the error

    "This error (HTTP 500 Internal Server Error) means that the website you are visiting had a server problem which prevented the webpage from displaying."

    We can connect to reporting services from Management studio.

    we are using ie7

    Please help us to fix this issue.

    Thanks in advance

    Regards,

    Sajesh.

  • Looks like a problem with the IIS on the Report server. Play around with the settings on that...

    Make sure, that in IIS, under Web Service Extensions, ASP.net is allowed.

    NM

  • Hi

    couple of questions.

    is IIS installed\configured on this server (do you have any websites)?

    Are you using a service account for the SSRS service?

    Can you post some screenshots for web service URL and report manager URL

    IIS is not required to be installed for SSRS2008, although it does use the same driver as IIS!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Good that I at least found out that SSRS 2008 does not require IIS. I was thinking it still uses IIS as SQL 2005.

    My installation of SSRS is in a development machine, which has IIS configured and running some websites. I don't know if the screen shot is going to help, as I am using the default settings. Anyway, here it is

    http://dl.dropbox.com/u/1784903/1.jpg

    http://dl.dropbox.com/u/1784903/2.jpg

    NM

  • NazerMohamed (6/2/2010)


    Good that I at least found out that SSRS 2008 does not require IIS. I was thinking it still uses IIS as SQL 2005.

    My installation of SSRS is in a development machine, which has IIS configured and running some websites. I don't know if the screen shot is going to help, as I am using the default settings. Anyway, here it is

    http://dl.dropbox.com/u/1784903/1.jpg

    http://dl.dropbox.com/u/1784903/2.jpg

    NM

    My reply was to sajesh, are you having the same issue?

    the following screenshot

    http://dl.dropbox.com/u/1784903/1.jpg

    Shows clear issues with the port configuration, you may want to check that!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Hi,

    Please see the attachment.May i know how i can configure IIS?What you mean by service account

    Regards,

    Sajesh

  • hi

    sorry, not screenshots of the web pages. Screenshots of the sections in report services configuration manager

    configuring IIS and service accounts are way beyond the scope of a post in this forum.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Hi Perry Whittle,

    Thank you for your post.Sorry for the wrong screen shots.plaese see the attached document for the Report services configuration manager settings.

    Thanks for spending time to help us

    Regards,

    Sajesh

  • hey sorry to distrub you ..

    are you sajesh nair or what ..

    juust chekking boss

    don't mistake me ok..

Viewing 9 posts - 1 through 8 (of 8 total)

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