Home > Reporting Services > Report Manager not loading after installing Sql Server 2008

Report Manager not loading after installing Sql Server 2008


Many of you will have installed the CTP of SQL 2008 , only to have found that Report Manager does not come up anymore.Well , there are some architechtural changes that you should take note of.

You see, Reporting Services doesn’t need IIS anymore. The guys at Microsoft have decided to end the reliance on IIS due to deployment and management headaches. Reporting Services can now interact directly with HTTP.SYS and respond to web requests sent to the server.

This does not mean that Reporting Services is now also a web server – it simply means that it doesn’t need IIS anymore. Now the thing is to keep this in mind when you’re installing Reporting Services 2008 on a server that already has IIS.

First , go to the new Reporting Services Configuration Manager Screen. This has changed since RS 2005.

You will notice a link called Web Service URL. Here you can set up the name of the Report Manager Virtual Directory. I normally leave this as is. The second section is more interesting.

The first setting, IP Address, determines how the incoming requests are handled. If you set it to “All Assigned”, which is the recommended setting, it means that any request coming in on port 80, and that uses the virtual directory name of Report Server ( or the same name as set in the first field ), will be sent to Reporting Services instead of IIS.

The second setting , “All Unassigned”, means that if no other service has registered a URL reservation for this virtual directory on this port, then give Reporting Services the request.

Now for the fix : some people have changed the setting to “All Unassigned” and found that Report Manager comes up. However, what I would is leave it to “ All Assigned “ and change the port to 8080.

The reason for this is because you cannot share port 80 with IIS. According to Microsoft , this is the case on Windows XP but I have also had this problem with Windows Server 2003.

Advertisements
Categories: Reporting Services
  1. Shriniwasan
    October 25, 2009 at 3:27 am

    Thanks much. Useful piece of information. In my case I also had to turn of the Secure Connection in the Reporting Services Configuration file. It was by default set to 2 and I changed it to 0.

  2. David
    March 24, 2010 at 9:13 pm

    Thanks this posting. It really explained well how IIS and Reporting Services co-exist, when asked to. Also, HUGE thanks to Shriniwasan Viswanathan for his comment. His tidbit was exactly what the doctor ordered, and I\’ve been looking for the answer for 2-3 days. Finally after re-installing everything ~8 times, I found this. Now Report manager is responding, and I can go on to figure out what the setting does and what is will be appropriate to set it.

  3. May 1, 2012 at 6:53 pm

    Very Good info, I struggled for this issue than I found your article.

  4. December 18, 2012 at 3:23 pm

    It’s difficult to find experienced people about this topic, but you sound like you know what you’re talking about!
    Thanks

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: