What are the Differences Between SSRS 2005 and SSRS 2008

Qns by Labels	Differences	SQL Server	SSIS	SSRS	T-SQL

__

Post a Job! $5 for 60 days

Few of the major differences between SSRS 2005 and SSRS 2008 are as follows:

• SSRS 2005 report server requires IIS, whereas SSRS 2008 comes with a build-in web server and hence does not require IIS.
• SSRS 2005 is multiple services architecture (Windows Service & IIS Service), whereas SSRS 2008 is a single service architecture (Windows Service) due to the presence of an inbuilt web server.
• SSRS 2005 deployment & configuration involves lot of effort and a little bit of complexity due to the dependency on IIS, whereas SSRS 2008 deployment is much simpler especially with the help of Reporting Services Configuration Manager.
• SSRS 2005 has less visualization components, whereas SSRS 2008 has a very rich set of visualization components like Dials, Gauges, Sparklines etc.

For more details, see the following articles:

• http://mytechnobook.blogspot.com/2010/06/difference-between-ssrs-2005-and-ssrs.html
• http://www.microsoft.com/sqlserver/2008/en/us/reporting.aspx