Keep in mind - Some settings that I list below could be different from your network or situation and may not necessarily apply to best practices.
----------------------------------------------------------------------------------------------------------
Install SQL Server Reporting Services and the Reporting Services Role on SCCM
----------------------------------------------------------------------------------------------------------
- Run SQL Setup from iso
- Add Features to an existing instance of SQL Server 2008 R2
- Choose MSSQLSERVER
- Feature Selection
- [x] Reporting Services
- For this feature, I could not specify the D: drive to install, this option was greyed out
- Service Accounts
- Choose SYSTEM (add other accounts later)
- (o) Install, but do not configure the report server (other options were greyed out)
- Next til finished
Login as payneb\Administrator and Open “Reporting Services Configuration Manager” and connect to database
- Verify service has started
- Check SQL Server Instance Product Version, should read “10.50.2500.0”
- If reads “10.50.1600”, then you need to reinstall SQL 2008 R2 SP1, otherwise the Reporting Services role in SCCM will NOT WORK!!!!
- http://www.microsoft.com/download/en/details.aspx?id=26727
- An explanation is provided here: http://bit.ly/LFzrHw
- Database tab
- Change database
- Create a new report server database
- Database Name: ReportServer (go w/ defaults)
- (o) Native Mode
- Finish
- Still logged in as payneb\Administrator, go to http://systemcenter/Reports (Use IE)
- Click on Site Settings
- Security tab > Add New Role Assignment as needed
- Add sccm.reporting user and other desired users
- Open SQL Management Studio and grant sccm.reporting user rights (and whoever else) to the new ReportServer databases
Add the Reporting Services role in SCCM. At this point, I logged in as myself on the SCCM server
- Administration tab > Servers and Site System Roles > Add Site System Role
- [x] Reporting Services Point
- Verify all information is correct, then click on Verify button
- UN: sccm.reporting, enter password
- Next, Finish
- [OPTIONAL] You can verify that the role installs successfully by using CMTrace and open the SRSRP.LOG and/or SRSRPSetup.log file
Monitoring tab > Reports
- Wait a few minutes and SCCM will populate this area w/ about 423 items
- At this point you can log back into http://systemcenter/Reports provided you gave yourself permission from the steps above. When using Internet Explorer, choose Run As Administrator. or use a different browser. You should also see reports listed here as well.
From here on, you can view reports, create subscriptions, etc.