Recreate SSRS TempDB

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 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 !


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s