NEW Reporting role -- The request failed with HTTP status 401: Unauthorized

[HaohmaruTachibana]

my current setup consists of 3 servers. main site current branch, sql server 2016, and dp server. Tthe main server has the basic roles and plus sup and endpoint. the sql server has the db role and the reporting role and dp is just that



long story short I had to remove and re-add the reporting role and after clean install (removed role, removed ssrs native, detached the DBs reboot both servers)

if I reinstall and don't use my third party trusted cert the role functions fine. however if I reinstall and use the ssl cert I get the 401 error you'll see below. mind you this was working a few days ago.



If I add the the ssl cert after the fact the console was not detecting it after ~8 hours. if there a way to have sccm reflect or switch to the new ssl binding?



can someone please provide some guidance.



The ssrs windows service is running with its own AD user account. and I can navigate login to https://xyz..../ReportServer/Reports





ssrsp log:





SMS_EXECUTIVE started SMS_SRS_REPORTING_POINT as thread ID 3940 (0xF64). SMS_SRS_REPORTING_POINT 11/21/2018 10:36:25 AM 3304 (0x0CE8)

This is a SRS Reporting Point Role as SRSRP registry key exists. SMS_SRS_REPORTING_POINT 11/21/2018 10:36:40 AM 3940 (0x0F64)

Waiting for changes for 0 minutes SMS_SRS_REPORTING_POINT 11/21/2018 10:36:40 AM 3940 (0x0F64)

Timed Out... SMS_SRS_REPORTING_POINT 11/21/2018 10:36:40 AM 3940 (0x0F64)

Set configuration SMS_SRS_REPORTING_POINT 11/21/2018 10:36:40 AM 3940 (0x0F64)

Check state SMS_SRS_REPORTING_POINT 11/21/2018 10:36:40 AM 3940 (0x0F64)

Check server health. SMS_SRS_REPORTING_POINT 11/21/2018 10:36:40 AM 3940 (0x0F64)

Successfully created srsserver SMS_SRS_REPORTING_POINT 11/21/2018 10:36:40 AM 3940 (0x0F64)

Reporting Services URL from Registry [https://xyz/ReportServer/ReportService2005.asmx] SMS_SRS_REPORTING_POINT 11/21/2018 10:36:40 AM 3940 (0x0F64)

The request failed with HTTP status 401: Unauthorized. SMS_SRS_REPORTING_POINT 11/21/2018 10:36:41 AM 3940 (0x0F64)

(!) SRS not detected as running SMS_SRS_REPORTING_POINT 11/21/2018 10:36:41 AM 3940 (0x0F64)







ssrssetup log:







<11/21/18 10:36:12> ====================================================================

<11/21/18 10:36:12> SMSSRSRP Setup Started....

<11/21/18 10:36:12> Parameters: \\xyc\D$\SMS\bin\x64\rolesetup.exe /install /siteserver:xyz1 SMSSRSRP 0

<11/21/18 10:36:12> Installing Pre Reqs for SMSSRSRP

<11/21/18 10:36:12> ======== Installing Pre Reqs for Role SMSSRSRP ========

<11/21/18 10:36:12> Found 1 Pre Reqs for Role SMSSRSRP

<11/21/18 10:36:12> Pre Req SqlNativeClient found.

<11/21/18 10:36:12> SqlNativeClient already installed (Product Code: {4D2C56FF-7F36-4B49-A97A-24F0522D41D7}). Would not install again.

<11/21/18 10:36:12> Pre Req SqlNativeClient is already installed. Skipping it.

<11/21/18 10:36:12> ======== Completed Installation of Pre Reqs for Role SMSSRSRP ========

<11/21/18 10:36:12> Installing the SMSSRSRP

<11/21/18 10:36:12> Passed OS version check.

<11/21/18 10:36:12> .NET Framework 4.0 Full profile is installed.

<11/21/18 10:36:12> Clean up old files

<11/21/18 10:36:12> Deleting \\?\D:\SMS_SRSRP, FAILED, Win32 Error = 2

<11/21/18 10:36:12> Cannot delete old installation directory D:\SMS_SRSRP. Error Code=2. Installation will continue.

<11/21/18 10:36:12> No versions of SMSSRSRP are installed. Installing new SMSSRSRP.

<11/21/18 10:36:12> Enabling MSI logging. srsrp.msi will log to D:\SMS\logs\srsrpMSI.log

<11/21/18 10:36:12> Installing D:\SMS\bin\x64\srsrp.msi SRSRPINSTALLDIR="D:\SMS_SRSRP" SRSRPLANGPACKFLAGS=0

<11/21/18 10:36:16> srsrp.msi exited with return code: 0

<11/21/18 10:36:16> Installation was successful.

<11/21/18 10:36:16> CTool::RegisterManagedBinary: run command line: "C:\Windows\Microsoft.NET\Framework64\v4.0.30319\RegAsm.exe" "D:\SMS_SRSRP\srsserver.dll" /unregister

<11/21/18 10:36:16> CTool::RegisterManagedBinary: Registered D:\SMS_SRSRP\srsserver.dll successfully

<11/21/18 10:36:16> Unregistered DLL D:\SMS_SRSRP\srsserver.dll

<11/21/18 10:36:16> CTool::RegisterManagedBinary: run command line: "C:\Windows\Microsoft.NET\Framework64\v4.0.30319\RegAsm.exe" "D:\SMS_SRSRP\srsserver.dll" /codebase

<11/21/18 10:36:16> CTool::RegisterManagedBinary: Registered D:\SMS_SRSRP\srsserver.dll successfully

<11/21/18 10:36:16> Registered DLL D:\SMS_SRSRP\srsserver.dll

<11/21/18 10:36:16> No versions of SMSSRSRP are installed. Installing new SMSSRSRP.

<11/21/18 10:36:16> Enabling MSI logging. srsrp.msi will log to D:\SMS\logs\srsrpMSI.log

<11/21/18 10:36:16> Installing D:\SMS\bin\x64\srsrp.msi SRSRPINSTALLDIR="D:\SMS_SRSRP" SRSRPLANGPACKFLAGS=0

<11/21/18 10:36:22> srsrp.msi exited with return code: 0

<11/21/18 10:36:22> Installation was successful.

<11/21/18 10:36:22> Installation was successful.

<11/21/18 10:36:22> ~RoleSetup().