SSRS Configuration Security Warning Resolutions- Microsoft SQL Server
Budget: $8 – $15 USD
I'm requesting assistance with troubleshooting the current SSRS configuration. The two report server web links are displaying security warnings:
- Web Link 1 shows “Not Secure”
- Web Link 2 displays “Your connection is not private”
Both SSL certificates were correctly bound during the SSRS setup. The HTTP and HTTPS endpoints for each link were registered using the following SPN commands:
Setspn -s http/MyReportServer1.MyDomain.com SSRS_ServiceDomainAccount
Setspn -s https/MyReportServer1.MyDomain.com SSRS_ServiceDomainAccount
Setspn -s http/MyReportServer2.MyDomain.com SSRS_ServiceDomainAccount
Setspn -s https/MyReportServe2r.MyDomain.com SSRS_ServiceDomainAccount
I registered the required SPNs using the SQL Server engine account with the following commands:
setspn -S MSSQLSvc/SQLSERVER1.domain.com:INSTANCENAME DOMAIN\sqlEngineService
setspn -S MSSQLSvc/SQLSERVER1.domain.com:PORT DOMAIN\sqlEngineService Subsequently, I configured the SSRS_ServiceDomainAccount in Active Directory to trust these SPNs by enabling delegation under its Delegation tab.
- Web Link 1 shows “Not Secure”
- Web Link 2 displays “Your connection is not private”
Both SSL certificates were correctly bound during the SSRS setup. The HTTP and HTTPS endpoints for each link were registered using the following SPN commands:
Setspn -s http/MyReportServer1.MyDomain.com SSRS_ServiceDomainAccount
Setspn -s https/MyReportServer1.MyDomain.com SSRS_ServiceDomainAccount
Setspn -s http/MyReportServer2.MyDomain.com SSRS_ServiceDomainAccount
Setspn -s https/MyReportServe2r.MyDomain.com SSRS_ServiceDomainAccount
I registered the required SPNs using the SQL Server engine account with the following commands:
setspn -S MSSQLSvc/SQLSERVER1.domain.com:INSTANCENAME DOMAIN\sqlEngineService
setspn -S MSSQLSvc/SQLSERVER1.domain.com:PORT DOMAIN\sqlEngineService Subsequently, I configured the SSRS_ServiceDomainAccount in Active Directory to trust these SPNs by enabling delegation under its Delegation tab.