Service Manager (SCSM) 2016 not displaying Reports via Console (How to fix it)
Service Manager (SCSM) 2016 not displaying Reports via Console
If you are here is because you have deployed your 2012/2016 environment and you realize that your Reports are not visible/accessible via the SCSM Console.
Problem/Symptom
On the Management Server saw this error under the Operations Manager Log.Source: Console Operations
Event ID: 33569
Cannot connect to SQL Reporting Services Server. Message= An unexpected error occured while connecting to SQL Reporting Services server: System.Net.WebException: The request failed with HTTP status 401: Unauthorized.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.EnterpriseManagement.Reporting.ReportingService.ReportingService2005.FindItems(String Folder, BooleanOperatorEnum BooleanOperator, SearchCondition[] Conditions at Microsoft.EnterpriseManagement.Reporting.EnterpriseReporting.FindItems(String searchPath, IList`1 criteria, Boolean And)at Microsoft.EnterpriseManagement.Reporting.EnterpriseReporting.FindItems(String itemPath)at Microsoft.EnterpriseManagement.Reporting.EnterpriseReporting.FindItem(String itemPath, ItemTypeEnum[] desiredTypes) at Microsoft.EnterpriseManagement.Reporting.EnterpriseReporting.GetFolder(String path) at Microsoft.EnterpriseManagement.Reporting.EnterpriseReportingGroup.Initialize()at Microsoft.EnterpriseManagement.Reporting.ServiceManagerReportingGroup..ctor(DataWarehouseManagementGroup managementGroup, String reportingServerURL, String reportsFolderPath, NetworkCredential credentials) at Microsoft.EnterpriseManagement.Reporting.ServiceManagerReportingGroup..ctor(DataWarehouseManagementGroup managementGroup, String reportingServerURL, String reportsFolderPath) at Microsoft.EnterpriseManagement.UI.SdkDataAccess.ManagementGroupServerSession.TryConnectToReportingManagementGroup() Remediation = Please contact your Administrator.
Resolution
If you are getting this error is because you haven register the SPN’s and delegated the appropiate permissions to Service Manager and Reporting Services.Open Command Line as administrator on the Management Server
Run the following commands:
This command will set the appropriate SPNs that are needed for SCSM and SSRS.
Setspn -A HTTP/SCSMDWSERVER.domain.com DOMAIN\SCSMServiceaccount
To list the SPNs
Setspn –L DOMAIN\SCSMServiceaccount
This link below also includes all the SPN/Kerberos and Reporting Services
https://msdn.microsoft.com/en-us/library/ff679930.aspx
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment