ConfigMgr and SSRS 2008
While answering a forum post I was reminded that SQL Reporting Services 2008 no longer requires IIS (see http://blogs.technet.com/andrew/archive/2007/12/04/sql-server-2008-reporting-services-no-longer-depends-on-iis.aspx for a good post on this). Thus, when rebuilding my ConfigMgr lab recently, I decided to use SQL 08 and SSRS 08 on Windows Server 08. The only notable thing, IMO, is that the configuration tool for SSRS 08 is a little more straight-forward and gives better explanations than the one in SSRS 05. They are actually very similar, so maybe it’s just because I’m used to the one in 05 now, but the first time I opened the one in 05, I had no idea what to do.
In the end, everything went as expected. SSRS installed fine (no IIS), the SRS Reporting Point installed without a hitch, the reports transferred quickly, and most importantly, all the reports worked – at least the ones I tested. Now granted, this is my home lab, but I didn’t see anything that should cause anyone any issues. Also note that the Windows firewall is enabled on all of my systems – SQL Server, ConfigMgr Site Server, Domain Controller, and clients; I actually force it to be on using a GPO. So, anyone who thinks that they need to turn it off, needs to reevaluate (maybe another post on that is in order).