Archive for May, 2008

Images of Joburg

May 27, 2008 Leave a comment

People were complaining that I only had pictures of Durban up on my blog. OK then , I’ve uploaded some pics of the Joburg skyline ( my favourite is the night shot ). Check out the Album on the main page. Note that unlike the Durban pics , I didn’t take any of these.

The Sandton skyline is coming along nicely, with the Radisson Hotel being the newest skyscraper under construction. Some way to go yet before it’s a proper city , but the indications are that by 2010 Sandton will have a "proper" skyline with a lot more buildings. I’ll put up some pics of Sandton next.
The other area that’s getting some nice buildings is the Point area in Durban , with the Spinnaker already up. Check out the following link for more on the Point development :
Another shameless plug for my hometown. And remember , we’re hosting Tech-Ed this year. It’s going to be the best Tech-Ed yet.
Categories: Hobbies

Report Manager not loading after installing Sql Server 2008

May 12, 2008 4 comments

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.

Categories: Reporting Services