Help! I've exhausted all options:
SRV1 = SCCM 2012 SP1 on WS 2008 R2 SP1
SRV2 = SQL 2008 R2 SP2 (CU5) & SSRS on WS 2008 R2 SP1
Not sure how long its been going on - though I had noticed that for a while the SSRS service was not automatically starting after rebooting SRV2.
Yesterday, I went to pull up a report on Power Management and Software version installed. when I went to HTTP://SRV2/Reports I saw the ConfigMgr_XXX folder - but no reports only a Data Source GUID.
When I connected to SCCM - no reports were visible in the Monitoring -> reports tree. The report options dialog was blank, but SRV2 was listed in the dropdown box. However no matter how often I chose it - it was blank the next time I looked.
I Removed the role and monitored its removal then reinstalled it - but only to get : 1014,1075,4951 and eventually 1016. It then repeats this every 60 minutes
I cannot find the 2 log files mentioned in Event 4951anywhere to monitor in CMTrace (srsrpSetup.log and srsrp.msi.log) to find what the issue is
I have even removed the Reports DB and reconfigured Reporting Service to recreate the DB. - This goes fine and the database is created. I can get to it using http://SRV2/Reports - but no CM12 reports are visible due to the role failing to install
I have tried several accounts when installing and none work - (Domain Admin, Domain User, SQL Admin - all with CM roles )
I am at a loss - don't really want to strip out SCCM as everything else is working