Native SSRS not detected as running. 401 Unauthorized

%3CLINGO-SUB%20id%3D%22lingo-sub-323967%22%20slang%3D%22en-US%22%3ENative%20SSRS%20not%20detected%20as%20running.%20401%20Unauthorized%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-323967%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20been%20having%20this%20issue%20for%20a%20while%20now.%20The%20SSRS%20Point%20is%20listed%20as%20not%20running%20under%20site%20status.%20However%20I'm%20able%20to%20run%20reports%20under%20the%20console%20or%20via%20the%20browser.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20SSRSP.log%20from%20the%20site%20server%20running%20the%20ssrs%20role%20show%20the%20following%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESet%20configuration%20SMS_SRS_REPORTING_POINT%201%2F22%2F2019%202%3A39%3A54%20PM%205292%20(0x14AC)%3C%2FP%3E%3CP%3ECheck%20state%20SMS_SRS_REPORTING_POINT%201%2F22%2F2019%202%3A39%3A54%20PM%205292%20(0x14AC)%3C%2FP%3E%3CP%3ECheck%20server%20health.%20SMS_SRS_REPORTING_POINT%201%2F22%2F2019%202%3A39%3A54%20PM%205292%20(0x14AC)%3C%2FP%3E%3CP%3ESuccessfully%20created%20srsserver%20SMS_SRS_REPORTING_POINT%201%2F22%2F2019%202%3A39%3A54%20PM%205292%20(0x14AC)%3C%2FP%3E%3CP%3E%3CSTRONG%3EReporting%20Services%20URL%20from%20Registry%20%5Bhttps%3A%2F%2F%3CSERVERNAME%3E%2FReportServer%2FReportService2005.asmx%5D%20SMS_SRS_REPORTING_POINT%201%2F22%2F2019%202%3A39%3A54%20PM%205292%20(0x14AC)%3C%2FSERVERNAME%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EThe%20request%20failed%20with%20HTTP%20status%20401%3A%20Unauthorized.%20SMS_SRS_REPORTING_POINT%201%2F22%2F2019%202%3A39%3A54%20PM%205292%20(0x14AC)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E(!)%20SRS%20not%20detected%20as%20running%20SMS_SRS_REPORTING_POINT%201%2F22%2F2019%202%3A39%3A54%20PM%205292%20(0x14AC)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EFailures%20reported%20during%20periodic%20health%20check%20by%20the%20SRS%20Server%20SQLSERVER.DOMAIN%3C%2FSTRONG%3E%20SMS_SRS_REPORTING_POINT%201%2F22%2F2019%202%3A39%3A54%20PM%205292%20(0x14AC)%3C%2FP%3E%3CP%3ERegistry%20change%20SMS_SRS_REPORTING_POINT%201%2F22%2F2019%202%3A39%3A54%20PM%205292%20(0x14AC)%3C%2FP%3E%3CP%3EWaiting%20for%20changes%20for%201%20minutes%20SMS_SRS_REPORTING_POINT%201%2F22%2F2019%202%3A39%3A54%20PM%205292%20(0x14AC)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20domain%20account%20under%20which%20the%20role%20is%20running%20is%20a%20registered%20spn.%20I%20have%20uninstalled%20and%20reinstalled%20the%20role.%20the%20web.config%20file%20for%20ssrs%20has%20the%20authentication%20method%20set%20to%20windows.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20really%20appreciate%20any%20help%20with%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-323967%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECM%20current%20branch%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EGeneral%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESite%20Setup%20and%20Client%20Deployment%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello,

 

I've been having this issue for a while now. The SSRS Point is listed as not running under site status. However I'm able to run reports under the console or via the browser.

 

The SSRSP.log from the site server running the ssrs role show the following:

 

Set configuration SMS_SRS_REPORTING_POINT 1/22/2019 2:39:54 PM 5292 (0x14AC)

Check state SMS_SRS_REPORTING_POINT 1/22/2019 2:39:54 PM 5292 (0x14AC)

Check server health. SMS_SRS_REPORTING_POINT 1/22/2019 2:39:54 PM 5292 (0x14AC)

Successfully created srsserver SMS_SRS_REPORTING_POINT 1/22/2019 2:39:54 PM 5292 (0x14AC)

Reporting Services URL from Registry [https://<servername>/ReportServer/ReportService2005.asmx] SMS_SRS_REPORTING_POINT 1/22/2019 2:39:54 PM 5292 (0x14AC)

The request failed with HTTP status 401: Unauthorized. SMS_SRS_REPORTING_POINT 1/22/2019 2:39:54 PM 5292 (0x14AC)

(!) SRS not detected as running SMS_SRS_REPORTING_POINT 1/22/2019 2:39:54 PM 5292 (0x14AC)

Failures reported during periodic health check by the SRS Server SQLSERVER.DOMAIN SMS_SRS_REPORTING_POINT 1/22/2019 2:39:54 PM 5292 (0x14AC)

Registry change SMS_SRS_REPORTING_POINT 1/22/2019 2:39:54 PM 5292 (0x14AC)

Waiting for changes for 1 minutes SMS_SRS_REPORTING_POINT 1/22/2019 2:39:54 PM 5292 (0x14AC)

 

The domain account under which the role is running is a registered spn. I have uninstalled and reinstalled the role. the web.config file for ssrs has the authentication method set to windows.

 

I would really appreciate any help with this.

 

Thanks

0 Replies