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

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 comment