SpacePants

Just wanted to provide some feedback. This is a very helpful guide, I followed it last week and upgraded to 1702 from 1606. the process took just under 3 hours for me. Before I started the update I backed up my ConfigMgr, SUS and Reporting services DB plus the cd.latest folder. Thanks again.

Thanks for passing that on,1702 here I come

So, should anyone have the same problem this is what I did: Remove Reporting services role from SCCM, closed console. Ran sql 2008 installer with a view to removing reporting services - it reported reporting services was not installed. (weird) Ran sql 2014 installer with a view to removing reporting services - it reported reporting services was not installed. (OK, that's also weird). Unattached the current SQL Report server and Report Temp DB databases. Reinstall SQL 2014 report services. Registered Reporting URL and created reporting databases in Reporting Services Configuration Manager 2014 Installed the Reporting services role in SCCM - (Warning - I had the blank database problem described here http://myitforum.com/myitforumwp/2012/10/10/reporting-services-site-role-setup-instance-blankempty/I followed the instructions in this post and all is OK now. Thanks for the help and advice offered by all.

@sccm_buff = thanks for the information. Something obviously went wrong here with my reporting services upgrade - I have a MSRS10_50.MSSQLSERVER folder (SQL 2008) but I don't have a MSRS 12.MSSQLSERVER directory (SQL 2014 ) as I would expect in the directory C:\Program Files\Microsoft SQL Server. I will reinstall today or tomorrow and report back.

I'd also like to know this as I am planning to upgrade from 1606 to 1702 early next week.

Thanks for taking a look guys. @GarthMJ = understood, I configured RBAC ages ago, only two other admins can run reports and yes the did use the website . I have (or had) some scheduled reports that fire once a month so I want to get this fixed before they fire off. thanks for taking a look at my post I'll try my steps tomorrow or Wednesday and report back to this forum., hopefully if someone else has this problem they may find this post. @sccm_buff = You had the same problem, was t after a SQL upgrade? Thanks for the detailed steps. I shall try the whole removal/reinstall of reporting services tomorrow or Wednesday. I may actually have a backup of my reports, I think may have done this before I upgrade from SCCM 2012 R2 to current branch last year. hopefully this won't be such a PITA (famous last words). Has anyone else come across this problem? Does anyone have any other comments before I make this change?

Hi All. Long time lurker here but now is the first time I have been moved to create an account and ask for some advice. I’m looking for a bit of direction on how to proceed as I’m a bit stuck, I’d like to fix this without breaking anything else in SCCM. I’m running SCCM build 1606 – Last week we upgraded the SQL instance hosting all out SCCM databases from SQL 2008 SP3 to SQL 2014 (this because we plan to upgrade to SCCM 1702). The SQL upgrade wizard reported that it upgraded all components successfully to SQL 2014 but when I opened the SCCM console all the reports are missing. Everything else in SCCM appears to be OK. Further investigation revealed. The Sql server Reporting services Service is not running - when I try and start it I get the error “ Error 2 – can’t find the service specified”. It turns out the executable it maps to named ReportingServicesService.exe does not exist in "C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\bin” If I try and launch the SQL reporting services configuration manager 2008 and 2014 console it is unable find a reporting server. So I guess SQL reporting is broken. I’m wondering what I should do to try and fix this. This is what I was thinking but it’s just a guess. Remove Reporting services role from SCCM. Uninstall SQL 2008 Reporting Services feature? Uninstall SQL 2014 Reporting services Feature? Unattached the current SQL Report server and Report Temp DB databases (would I need to do this?). Reinstall SQL 2014 report services, configure reporting service point. I’d a appreciate any advice, I did have a few custom reports configured but I don’t mind setting them up again. The main thing is to get reporting services up and running again. Thanks in advance.