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.
Added domain controller computer to reportingprivgroup and reports are running for users who reach them by domain name - still not for those who reach crm by ip address . And also it is run much slower than before .
Any suggestion to solve it basically ?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Share
Report
5
All responses (
Answers (
