when i run any report it gives the following error 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) Invalid object name 'HG_AX09TempDB.dbo.PersistedStream'.

when i run any report it gives the following error 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) Invalid object name 'HG_AX09TempDB.dbo.PersistedStream'.

Hi jhsharma, Generally, the issue is caused by the ReportServer temp database(ReportServerTempDB, in this case, it is HG_AX09TempDB) is missing. To solve the issue, please follow these steps: 1. Connect the database server that host the report server databases using SQL Server Management Studio(SSMS) 2. Create a new database, named HG_AX09TempDB 3. Then, run the CatalogTempDB.sql script. This script can be found from the ReportServer folder(In Microsoft SQL Server Reporting Services 2008, it is in "C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer" by default). Now, we are able to run reports again. Besides, based on the error message, please also check if the disk has enough space to run SQL Server database engine. If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT

Dear Sir When I try to add the HG_AX09TempDB , It gives me the erorr message that this database is already exists. I am not able to add the database what to do ? JHSharma

Hi JHSharma, We can delete it, and then recreate it. Thanks, Jin ChenJin Chen - MSFT

Hello Mr. Sharma, WE have SQL Server 2008 sp2 for our database and SQL Server 2008 SSRS running. I am getting an error message when i click on Report Manager --> Site Settings --> Schedules It suddenly started happening, i had no issues like for almost a year. Error Msg: 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 For more information about this error navigate to the report server on the local server machine, or enable remote errors Along with this error, i have started getting errors on the subscription page where the reports are not been emailed. ERROR: Failure sending mail: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.Mail will not be resent. Please help me, I am stuck and not able to figure out what is going on .