- Andrew Kos
- Bill Burlein
- Bryan Williams
- Christian Vozar
- Jeff Brown
- John Kraus
- Joseph Mak
- Mark Daugherty
- Matt Van Bergen
- Melissa Geoffrion
- Michael Kang
- Michael Chan
- Michael Hodgdon
- Mike Motherway
- Molly McDaniel
- Nadia Maciulis
- Pat McLoughlin
- Paul Michelotti
- Puru Hemnani
- Rohit Srinath
- Ryan Lunka
- Tom Kelly
Installing and Configuring SQL Server 2005 Reporting Services
Saturday, June 13, 2009
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
- 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.
Rohit is a Microsoft Certified Solution Developer (MCSD.Net) with more than 10 years of experience. He has expertise in...
- Invisible requirements within Business requirements
- Building a better Options Predicate
- Extensionless URLs with Adobe Experience Manager
- The Life of a Tester in Adobe CQ World!
- Limitations of the CQ Parsys Model and the Implementation of a Nested Paragraph System
- Using Apache FOP to generate a PDF document based on a form submission data
- Configuring SAML in AEM 5.6
- Why You Should Get the WCM Experts Involved Early