Tuesday, 27 March 2012

SSRS Basic Interview Questions And Answers - Part 2

Q: What is difference between SSRS 2005 and 2008 ?

Difference between  SSRS 2005 and SSRS 2008
SQL Server 2005 Reporting Services
SQL Server 2008 Reporting Services
Multiple service architecture (IIS Service & Windows Service)
Single service architecture (Windows Service)
Depends on IIS
Comes with Built-In Web Server and hence does not depend on IIS
Complex deployment due to the need for separate configuration for IIS
Deployment is simple due to inbuilt web server and Reporting Services Configuration Manager
Charts, Dials etc. had to be separately installed and integrated
Comes packaged with Charts, Dials, Indicators, Sparklines etc.
Limited exporting options
More exporting options including Microsoft Word etc

No comments:

Post a Comment