Installing and Configuring SQL Server 2005 Reporting Services

Since past one month, couple of my friends asked me how to install and configure SQL Server 2005 Reporting Services on Vista. I had to recall what I had done few quarters ago. I also redirected them to this Microsoft KB.
All the steps are very clearly mentioned here and all we need to do is to follow the steps and make sure the following things are in place.

• Uninstall the older version of Reporting Services [SQL Server 200 Reporting Services] before starting with this version.
• Once installation is done go to “Reporting Services Configuration” tool and make sure all the configuration items are in GREEN.
  • Server Status: Running
  • Report Server Virtual Directory: Is set to “ReportServer”, else create with the same name and preferably under Default Web Site.
  • Report Manager Virtual Directory: Is set to “Reports”, else create with the same name and preferably under Default Web Site.
  • Windows Server Identity: Service name should be “ReportServer” and Service Acocunt should be “LocalSystem”
  • Web Service Identity: Select “Classic .NET AppPool” for both Report Server and Report Manager. Also ASP.Net Service Account should be “NT Authority\NetworkService”
  • Database Setup: Database name as ReportServer [This should be alredy present or create new] and DB version should be C.0.8.54
  • Initialization: Automatically gets initialized else click on Initialize button.
  • Click “Apply” and the Reporting Services configuration is done.
• Check if the RSWebApplication.config [located C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager] has ReportServer defined between the “ReportServerVirtualDirectory” tags
     <UI>
        <ReportServerUrl></ReportServerUrl>
        <ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
        <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
     </UI>
• Restart IIS, ReportServer, and SQL Server if required.
• You can access the reports after publishing, using the link [ http://localhost/Reports/Pages/Folder.aspx ]

So ENJOY Installing, Configuring, and using SQL Server 2005 Reporting Services.