After logging into my SCCM 2012 R2 server and running a report, I was getting an error to check network connectivity to the Report Server. After logging into my SQL 2012 SP2 server, I saw the following error message every time I ran a report:
Log Name: Application
Date: 12/5/2014 10:32:42 PM
Event ID: 7886
Task Category: Server
A read operation on a large object failed while sending data to the client. A common cause for this is if the application is running in READ UNCOMMITTED isolation level. This connection will be terminated.
I checked the database size and initially thought the autogrowth threshold was low. I was still getting the error after adjusting the autogrowth so I then thought it might be an issue with the database itself and ran a DB check.
ALTER DATABASE ReportServerDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
DBCC CHECKDB (‘ReportServerDB’, REPAIR_ALLOW_DATA_LOSS);
ALTER DATABASE ReportServerDB SET MULTI_USER;
I had to run these commands couple of times to fix the corruption in the database.