Tuesday, November 22, 2011

Simple concept: SSRS authentication

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


[Answer]:


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:



<Authentication>
<AuthenticationTypes>
<RSWindowsNTLM/>
</AuthenticationTypes>
<RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>
<RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>
<EnableAuthPersistence>true</EnableAuthPersistence>
</Authentication>




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


More on that: Authentication Types in Reporting Services