I have a situation that SSRS stock on loading forever and it did happen all of a sudden . Reverting to an old snapshot of windows did solve the problem for two times and around a month but again the problem arises and the last time , even getting back to a 3 old week snapshot did not work!
The windows event viewer message is as follows :
Monitoring test failed: Test Title: Check report server from SRSDataConnector.: Machine: ****: ServerRole: SrsDataConnector
Test Log:
System.Web.Services.Protocols.SoapException: The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation.
at Microsoft.ReportingServices.Library.ReportingService2005Impl.ListChildren(String Item, Boolean Recursive, CatalogItemList& CatalogItems)
at Microsoft.ReportingServices.WebServer.ReportingService2010.ListChildren(String ItemPath, Boolean Recursive, CatalogItem[]& CatalogItems)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.Crm.ReportingServices2010.ReportingService2010.ListChildren(String ItemPath, Boolean Recursive)
at Microsoft.Crm.Monitoring.Tests.ReportServer.CheckReportServerFromSrsDataConnector.Execute()
at Microsoft.Crm.Monitoring.Engine.MonitoringRuntime.ExecuteMonitoringTest(MonitoringTestBase test, Int32 attempts)
rsAccessDenied400The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation.https://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Exceptions.ErrorStrings&EvtID=rsAccessDenied&ProdName=Microsoft SQL Server Reporting Services&ProdVer=15.0.1102.962Microsoft SQL Server Reporting Services15.0.1102.962127OsIndependent1033ReportingServicesLibraryThe permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation.
.
It says network service need more permissions. I tried to give permissions in AD, SQL, report folder ,... . Nothing did work!
SQL sever log is as follows :
Date 26/07/1401 11:34:48 ق.ظ
Log SQL Server (Current - 26/07/1401 10:39:00 ق.ظ)
Source Logon
Message
Login failed for user '[Domain]\[Computername]$'. Reason: Could not find a login matching the name provided. [CLIENT: ]
Sql reporting services logon is a custom AD user, not used by any other one, Log on for dynamics crm services are network service.
