Reporting Services Single Sign On (SSO) Authentication - Part 1
This will be the first in a series of posts related to setting up single sign on for SQL Reporting Services. As you may know SQL Reporting Services supports forms authentication and there is a forms authentication sample that can be found here. By leveraging the logic in the sample we can incorporate SSO (isngle sign-on) behavior into the SQL Reporting Services (SSRS) environment. A working Visual Studio 2010 solution is uploaded here.
There are typically two scenarios that define single sign-on. The idea behind both is that the user only has to enter their credentials once and can access multiple applications from that single authentication action.