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

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s