Forum Discussion

NishantApturkar's avatar
NishantApturkar
Copper Contributor
Jun 18, 2026

SSRS reports not working

Hi Microsoft team,

 

We are looking for tech support on an issue with SSRS reports that are used in one of our applications.

 

The details of the issue are as foll:

 

 

When Trying to access an SSRS ReportServer instance (either through the SOAP Service, or directly from the browser) does not work. There are  Errors observed in the log files as well as the user interface .

 

The error message is

 

An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database.

 

The user interface fails to load Report as a result

 

 

Attached are the SSRS log files from the last month from one of the servers.

The last time reports were successfully accessed was on Friday, June 15th. Starting this Monday all functionality stopped working.

 

This environment has 4 SSRS servers under an High Availability AGL.

 

RSManagement log files indicate that the ReportServer schemas may be in an inconsistent state

 

|FATAL|8|Database upgrade failed!!  The database may now be in an inconsistent state.

 

Further research indicates that this may be corrected by the following procedure…

 

Stop SSRS services

Backup and delete ReportServer and ReportServerTempDB databases

Start the SSRS services

Use the wizard to create a new ReportServer set of databases

Stop the SSRS services

Delete the new (empty ReportServer) database

Restore the backup of the ReportServer (from step 2 - do not restore the temp database)

Fix schema of ReportServer.dbo.Catalog.PropertyField and ReportServer.dbo.Segment.Content (change columns from ntext to nvarchar(max))

Start the SSRS services (Monitor the RSManagement log file)

Verify

 

Backout if fail: (Stop Services, Restore the databases, Restart Services)

 

This may also include refreshing of encryption keys and removing servers from the AGL prior to this procedure

 

Can you please help identify what could be a possible root cause for this issue, confirm if the steps listed below present a plausible solution, and advise on any additional triaging steps or corrective procedures?

 

Thanks in Advance

No RepliesBe the first to reply