Hi, Can anybody tell me how ssrs form based authentication works with report portal. I am not able to crack it. I have downloaded SSRS_Config utility from report portal connection page and updated the patch by selecting ssrs installation folder and report portal xaml file. But i am not understanding how this one is working. Please help me out.
Currently I am using SQL server 2012. I want to implement forms authentication. I have applied that patch (ssrs configuration utility) but I need clarifications on this. Can u tell me the steps after applying that patch what I need to do? to apply role based security i need form based authentication only. Anonymous authentication I have already implemented. please help me
After applying SSRS config utility patch. SSRS report manager identifying only those users which is created by report portal admin. till now it is all fine, Now i am logging in as admin into report portal and After that whenever I am clicking the SSRS reports another login password prompt is coming(login.aspx).
SSRS Config utility lets you pick only SQL Server 2005, 2008 and 2008 R2. It has not been tested with SQL Server 2012. Please set up your server authentication manually by using this article:
SSRS Config utility requires one step: select the authentication mode and click Update. There is no documentation.
Here is what happens underneath. When you select forms authentication the config utility will change config files and copy Microsoft.Samples.ReportingServices.CustomSecurity.dll. During the authentication phase the following steps will take place:
1. ReportPortal will send the LogonUser authentication request to SSRS report server with ReportPortal user name and password http://technet.microsoft.com/en-us/library/aa225885(v=sql.80).aspx 2. The report server will look at ReportServer\rsreportserver.config config file and call the Microsoft.Samples.ReportingServices.CustomSecurity.dll 3. Microsoft.Samples.ReportingServices.CustomSecurity.dll will look for xmla.udl for the connection string to ReportPortal database and run an SQL query against AppUser table 4. Once the authentication is successful, SSRS LogonUser authentication request sets value for sqlAuthCookie cookie. 5. All subsequent request will send SSRS report server the sqlAuthCookie cookie
In your case, the problem might arise when SSRS is on another machine and different subdomain. In that case, the sqlAuthCookie will be set only for ReportPortal and not SSRS server web domain. ReportPortal can resolve this problem by reposting the sqlAuthCookie to your SSRS server. For this you ned to:
1. Run the following SQL against ReportPortal database:
Thank you very much for your quick response . Now I am able to authenticate ssrs reports with Report Portal users. I tested SSRS Config utility 2008 R2 with SQL server 2012. It worked for me.
Report Portal
SSRS Form authentication with Report Portal
Posted - 04/17/2014 : 12:48:05
I tested SSRS Config utility 2008 R2 with SQL server 2012. It worked for me.