We have Report server services in SharePoint Integrated mode and it was working up until last week but now when ever we are trying to open a report or data source we are getting the below error
Report Server could not access this web application's content database. The application pool account may not have permission. Navigate to the properties page of this SQL Server Reporting Services service application and ensure it has appropriate permissions. ---> Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException:
When i went through the event viewer i am seeing the below
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
But the SharePoint functionality is working fine only thing which is not working is the report server .I checked the permissions of the report service application account on the content DB and its fine
Can you please suggest what else i need to do
Update 1 : I deleted the service application and recreated again but its still happening again , i am not sure where i am going wrong
Update 2 : I restarted all the SharePoint servers and also checked whether the service application account can logon to SQL and the issue is still there
Update 3 : I have even now uninstalled and re created reporting services from Scratch and the issue is still there
Thanks