Showing posts with label head. Show all posts
Showing posts with label head. Show all posts

Tuesday, March 27, 2012

Forms Based Authentication

Sorry to revive a previously discussed point, I've been trying to get my head around the http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs_topic3 article given in a previous post. I think this is the solution we require but it raises a few issues that I would like some help on. What we are trying to do, is when the user logs on to the .net application, he is authenicated on the report server at the same time. So the user only sees one authenication process and is assigned a role from the report server to limit his/her access to reports. The user credentials at the moment are kept separate to the reportserver, i.e a different datasource and this will be modified slightly to include the report server role mappings. Access to reports is done using a slightly customised ReportViewer control included with SRS.

1. In the development environment we obviously publish different reports for differing clients. These reports are driven from differing databases and so are the user credentials for the application. Is it possible to develop a solution to encapsulate this need? I was thinking of one security extension that accepts the name of the application as a parameter and changes behaviour based on that. I'll probably use the authority parameter?

If I have completely missed the point here, please let me know!!!

Thanks in advance,

Mike.You could store the credentials required for each report in the report server.
And you could give selective permissions to the various folder/reports in the server.
Would that satisfy the requirements?

Thanks
Tudorsql

Forms Authentication Problem

I expect that this is a trivial problem, but I've banged my head on it
for long enough. I'm hoping there's someone out there that can help!
:-)
I have the MS sample for forms authentication
(http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp)
working just fine. Once I got that working, I translated it to VB.
(We're a VB shop, so if/when I roll out RS, pretty much everything
needs to be in VB.) As far as I know, I've converted it very
accurately and exactly. However, when I try to run the VB version
(e.g. navigate to http://localhost/ReportServer/logon.aspx), I receive
the following error:
================================================== Server Error in '/ReportServer' Application.
----
Parser Error
Description: An error occurred during the parsing of a resource
required to service this request. Please review the following specific
parse error details and modify your source file appropriately.
Parser Error Message: Could not load type
'Microsoft.Samples.ReportingServices.CustomSecurity.Logon'.
Source Error:
Line 1: <%@. Page language="vb" AutoEventWireup="false"
Codebehind="Logon.aspx.vb"
Inherits="Microsoft.Samples.ReportingServices.CustomSecurity.Logon" %>
Line 2: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0
Transitional//EN">
Line 3: <HTML>
Source File: C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\logon.aspx Line: 1
----
Version Information: Microsoft .NET Framework Version:1.1.4322.573;
ASP.NET Version:1.1.4322.573
==================================================
It seems as though RS is not loading the appropriate assembly. Can
anyone shed any light on this?
Thanks a lot!
Brad.OK, I think I've solved my own problem. In VB, I needed to add the
<%@. Assembly Name="Microsoft.Samples.ReportingServices.CustomSecurity"
%> directive to the aspx pages so that the right assembly would get
loaded. I hope that helps others. :-)
Brad.
On Wed, 01 Sep 2004 16:26:42 -0600, Bradley Plett <plettb@.hotmail.com>
wrote:
>I expect that this is a trivial problem, but I've banged my head on it
>for long enough. I'm hoping there's someone out there that can help!
>:-)
>I have the MS sample for forms authentication
>(http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp)
>working just fine. Once I got that working, I translated it to VB.
>(We're a VB shop, so if/when I roll out RS, pretty much everything
>needs to be in VB.) As far as I know, I've converted it very
>accurately and exactly. However, when I try to run the VB version
>(e.g. navigate to http://localhost/ReportServer/logon.aspx), I receive
>the following error:
>==================================================>Server Error in '/ReportServer' Application.
>----
>Parser Error
>Description: An error occurred during the parsing of a resource
>required to service this request. Please review the following specific
>parse error details and modify your source file appropriately.
>Parser Error Message: Could not load type
>'Microsoft.Samples.ReportingServices.CustomSecurity.Logon'.
>Source Error:
>
>Line 1: <%@. Page language="vb" AutoEventWireup="false"
>Codebehind="Logon.aspx.vb"
>Inherits="Microsoft.Samples.ReportingServices.CustomSecurity.Logon" %>
>Line 2: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0
>Transitional//EN">
>Line 3: <HTML>
>
>Source File: C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
>Services\ReportServer\logon.aspx Line: 1
>
>----
>Version Information: Microsoft .NET Framework Version:1.1.4322.573;
>ASP.NET Version:1.1.4322.573
>==================================================>It seems as though RS is not loading the appropriate assembly. Can
>anyone shed any light on this?
>Thanks a lot!
>Brad.sql