Tuesday, November 22, 2011

Simple concept: SSRS authentication

[Question]: How to figure out what authentication does SSRS use? Is Kerberos enabled ?


Go to the box where SSRS service is running;
"{System drive}:\Program Files\Microsoft SQL Server\MSRS{some numbers}.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config"

Check the section: "Authentication"

For example, the value for SSRS authentication without Kerberos which SSRS service runs under not NetworkService or LocalSystem account:


The explanation of the value is here - How to: Configure Windows Authentication in Reporting Services

More on that: Authentication Types in Reporting Services