An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError) Get Online Help Invalid object name ‘ReportServerTempDB.dbo.TempCatalog’. Could not use view or function ‘ExtendedCatalog’ because of binding errors.

For this Error ,we need to check some of basic information,in your SQL Server management  check on DB’s list like:

ReportServerTempDB is available or not, if not?

then go to to MS-SQL 2008 r2 Installation folder and Check there ReportServerTempDB.mdf, ReportServerTempDB_log.ldf’ are available or not?

If Yes.

Then Follow the Below Solution

CREATE DATABASE ReportServerTempDB

ON (FILENAME = ‘C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\ReportServerTempDB.mdf’),
(FILENAME = ‘C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\ReportServerTempDB_log.ldf’)
FOR ATTACH;

And then Rn your SSRS Report,paste the SSRS Report URL in Internet ,here you can see the Report.

Hope This will Help you…!

Advertisements

About nijamkhan

I am simple Hardworking,and i would like improve the Knowledge time by time
This entry was posted in Uncategorized. Bookmark the permalink.

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