.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

ssrs forms authentication

Posted By:      Posted Date: September 20, 2010    Points: 0   Category :Sql Server


i am using ssrs 2008. i am trying to implement forms authentication in ssrs. followed the steps in the link http://msdn.microsoft.com/en-us/library/ms160724(v=SQL.100).aspx#2. after restarting the reporting services, i am able to connect to reportserver and able to login as well. but when tried to connect to report manager, i get error as below


The website cannot display the page

This error (HTTP 500 Internal Server Error) means that the website you are visiting had a server problem which prevented the webpage from displaying.

For more information about HTTP errors, see Help.


the webservice url and report manager urls are configured as  http://myserver:8080/reportserver and http://myserver:8080/reports respectively.

any help is greatly appreciated.




Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find i

View Complete Post

More Related Resource Links

U?sing Forms Authentication and connecting between SSRS ans SSAS

In our current production environment, we have SSRS setup to use Forms Authentication to verify the users. For our data sources, we are using 2 different data models - 1 is used to point at the "raw" sql in the database - and the second model is to point at a SSAS cube. currently, all users can see all data. we now have a requirement to limit the data the a user can see from the Fact table dependant on the Portion that they are assigned to (and a user might be assigned to more than one Portion. we have set this new requirement in the "raw" SQL model using a security filter - and all working well we have set the filtering up in the cube  - using a stored procedure in the Role "dimension data" tab which receives the user name and retruns the MDX required for the filtering - and it works if we connect to the cube via SQL management studio. However, if we connect from Reporting Services, we can not get the UserName "transferred over" and therefore the filtering doesnt work. n.b. we are using Shared data sources for our reports does anyone out there know of a way of making this work - or do we go for Kerberos ??    

SSRS Forms authentication button click does nothing


I followed the instructions from http://msftrsprodsamples.codeplex.com/wikipage?title=SS2008%21Security%20Extension%20Sample&referringTitle=Home and tried to set up the sample to work on my localbox.  I have done everything and when I go to the Report Manager, I get redirected to the UILogon page and I am able to attach and debug. 

However, for some reason, none of the button click events are working.  When I click on Register, it simply reloads the page without invoking the BtnRegister_Click method.  Could this be a result of having built the project using VS2008 instead of VS2005 since the sample says it doesn't work with VS2008?  If so, what can I do so that it works with VS2008?

Thanks in advance,

SSRS forms authentication error:An error occurred while attempting to get the ReportServer Url. The

I have managed to get the Forms Authentication sample to work bu there is a hitch. I am running Report Server and Report Manager on the same(test) PC. I can logon to the Report Server without a problem but when I try logon from the UILogon.aspx page for Report Manager I receive the following error:

An error occurred while attempting to get the ReportServer Url. The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
An error occurred while attempting to get the ReportServer Url. The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
An error occured while attempting to get the ReportServer Url. The RPC server is unavailable.(Exception from HRESULT: 0x800706BA).

I can register users which suggests that the page can connect to the database.

Any help???

Problem with SSRS Forms Authentication


Hi All,

I tried SSRS with Forms based authentication. I followed the below link


I am getting null value at the below code line ...[This entire code has been downloaded from the link http://www.codeplex.com/SqlServerSamples/Release/ProjectReleases.aspx?ReleaseId=4000 ]

 string cookieName = response.Headers["RSAuthenticationHeader"];

In "Headers" there is no key as RSAuthenticationHeader and returning null.

Before debugging all this code, done like this....
As per "Readme_FormsAuthenication.htm " file,

1)changed all the config keys of "Report Server and Report Manager" of installed paths.

2)Pasted the .aspx pages in the corresponding "Report Server and Report

SSRS 2008R2 Forms Authentication - service won't start: rshost ERROR: Error in managed ServiceMain,


I implemented a forms authentication solution based on the MSDN sample. However, when I attempt to start the reporting services service either via Services or the RS Config tool, I get the following error in the reporting services logfile:


rshost!rshost!b04!04/12/2011-22:37:21:: e ERROR: Error in managed ServiceMain, error=0x8007000b

I have not been able to find any information around this error. Please help!!

Explained: Forms Authentication in ASP.NET

This module explains how forms authentication works in ASP.NET version 2.0. It explains how IIS and ASP.NET authentication work together, and it explains the role and operation of the FormsAuthenticationModule class.

Using Forms Authentication in ASP.NET - Part 1

Classic ASP developers often had to "roll their own" authentication scheme, however, in ASP.NET much of the grunt work has been taken out. This article outlines how things have changed and how FormsAuthentication can be used to secure a Web site with a minimal amount of code.

ASP.NET Forms Authentication - Part 1

Often, in legacy Web applications, users authenticate themselves via a Web form. This Web form submits the user's credentials to business logic that determines their authorization level. Upon successful authentication, the application then submits a ticket in the form of a cookie, albeit a hard cookie or session variable. This ticket contains anything from just a valid session identification access token to customized personalization values.

ASP.NET forms authentication with roles

.A timeout is specified in minutes. This is "time since last request" not the "time since login". If a login is indicated to be persistent (described later) this is ignored.
.A protection method is specified for the cookie.
Next I wanted to specify a folder to which access is restricted to people who have logged in. To do this I entered the following code in the web.config file (beneath

Forms Authentication in ASP.NET

In this tutorial you will learn about Forms Authentication in ASP.NET 2.0 - Forms Authentication class, Cookie Domain, Forms Cookies, The Login Control, Signin, Signout, Authenticate, Redirect, Login Status, Login Name and Login View Controls.

Problems with Forms Authentication in DD 4 site


Hello,  I am seeing a strange problem with Forms Authentication in my DD site.   A user logs into and can view/edit/delete data all day, but when they execute a Custom Filter against data (for example , a control DynamicData/Filters/CustomerLastNameSearch.ascx ) then the site auth fails, and redirects to the log in screen.

in web.config I have

     <authentication mode="Forms">
            <forms name=".Star" loginUrl="~/Login.aspx" protection="All" defaultUrl="~/Default.aspx" path="/" timeout="43200" cookieless="UseCookies" />     

Offhand, I am thinking two things : that DynamicData/Filters path requires some special handling for some reason, or the control extension ascx is causing auth to get confused.   Has anyone else experienced this or have any suggestions?  Thanks!

SSRS 2005 "Mixed" Authentication Mode


I have a web application where users can authenticate using either SiteMinder or Windows domain accounts.  This is actually configured as two separate virtual directories within IIS 6.  Both applications need to use the same instance of SSRS.  Is it possible to configure the SSRS web application so that if a user is authenticated by SiteMinder it impersonates a Windows account, but if they are already Windows-authenticated that account is used instead?

Forms based users being prompted for windows authentication login for My Sites photos in user lists

Here's an issue I didn't see coming for our forms based authentication users. 

We have a web application extended to an external url to handle forms based authentication for users outside of our domain. Our setup looks like this...

Internal Users/Windows Authentication - moss.domain.com
External Users/Forms Based - mossext.domain.com
My Site for Internal Users - mysites.domain.com

When our forms based users are accessing user lists, or discussion pages that display user pictures, they are getting a windows authentication login for our internal users (mysites.domain.com) who have populated their my site with personal photo.

How do we fix this? 

403 Forbidden - Forms Authentication


Form template has cascading dropdown lists.  When item selected from first list, form code executes a FileQueryConnection to retrieve data from a list to populate 2nd listbox.  Getting 403 forbidden when explicitely attempting to retrieve data from code.  Form is using connections from a data connection library.  The template works perfectly when deployed to a windows authenticated site.  Fails when executed from the forms authenticated site.


Issue with Forms Authentication


 I'm in the middle of converting an intranet application to use forms authentication. The authentication process works fine for the core application and all the nested classic asp pages. However, my nested asp.net applications do not work. I have mapped their web.configs to the correct login url. If I attempt to access them after logging in, I am automatically redirected to the homepage of the intranet application. If I try to access them directly, I am redirected to the login screen, as I should be, and then the intranet homepage after the login process, instead of the page I need to access.

At first, I thought there might be some remnant of the security processes in the nested applications, but it does it for applications that have no security processes other than the one for the core intranet.

Since this is my first crack at using forms authentication, I'm assuming I've missed some step. Any ideas?

Here is the section of my web.config:

<authentication mode="Forms">

      <forms loginUrl="~/folder/loginpage.aspx" name="Cookie Name"></forms>


      <deny users="?" />
      <allow users="*"/>

Automatic expiration of forms authentication when user closes the browser windows without signing ou

Dear all, can u tell me how to automatically sign out a user if he/she closes the browser window without signing out. I'm using Forms Authentication.   Thanks 

Forms Authentication Add SQL Database Variable

I am using Forms Based Authentication I have extended the Forms Authentication Tables creating a custom table called Profile_Contact that holds the user's GUID, username, email address, and other information. I have another table called Profile_Account which holds company account information such as Company Name, address info, phone numbers etc. This table has a Key Field called IDProfileAccount. I include the IDProfileAccount field in the ProfileContact user table so I can associate the user with a specific Company.For the login page, I am using a basic login page created with using the Visual Studio login controls.When the user logs in, they are sent to the appropriate page as identified by the role the user has been given. This all works great. Now I need to extend the login page so that when the user logs in not only is the user's name and GUID placed in session, I would also like to have the IDProfileAccount record placed in session as well so that I can filter the records the user sees as only those records of the Company the user is associated with. I know how to add static variable to a session and how to retrieve them to filter data, what I need to know is how to retrieve the data from the SQL table on login and sending it to the session. I would think it would be something along these lines:Partial Class login Inherits System.Web.UI.Page Protected Sub Logi
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend