Since all of the system center products are based on SSRS. It’s time to do some basic error resolving when the reporting does not work.
In this case there was the reporting services tempdb that could no longer be brought online. So I recreated the temp db. This was for a system center essentials installation.
First delete the old tempDB.
Then create a new database with the correct name.
Match the collation settings with the ReportServer DB
Recreate the user NT AUTHORITY\NETWORK SERVICE
Recreate the RSexecRole ( Similar to ReportServer DB )
And add the created user
Run query ( found under Reportserver location , CatalogTempDb.sql )
And verify result
And now test the reporting … Success !