I have followed exactly what the MSDN white paper asked to implement the Form
based security. I have created the useraccount database,registered few new
users in there and then logged in the RS Report Manager and gave the browser
rights to the new users on a folder and reports which all works fine.But when
I log in with the new registered user I can log in the Report manager but the
page does not display any reports or folders!! what am I doing wrong please
help!!!Hi shabab where u got that information i.e formbased security.
can pls refer that link?
Thanks!
simmi
"shahab" wrote:
> I have followed exactly what the MSDN white paper asked to implement the Form
> based security. I have created the useraccount database,registered few new
> users in there and then logged in the RS Report Manager and gave the browser
> rights to the new users on a folder and reports which all works fine.But when
> I log in with the new registered user I can log in the Report manager but the
> page does not display any reports or folders!! what am I doing wrong please
> help!!!|||for example, Forms Authentication). Here's
a white paper that can get you started
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp
also there is one very nice article extended on this white paper which is
published on devex. go to google and search for form based authentication in
MS RS...its by Harden ..let me know if you can find otherwise I will dig into
my favourites and let you know.
good luck
"simmi" wrote:
> Hi shabab where u got that information i.e formbased security.
> can pls refer that link?
> Thanks!
> simmi
> "shahab" wrote:
> > I have followed exactly what the MSDN white paper asked to implement the Form
> > based security. I have created the useraccount database,registered few new
> > users in there and then logged in the RS Report Manager and gave the browser
> > rights to the new users on a folder and reports which all works fine.But when
> > I log in with the new registered user I can log in the Report manager but the
> > page does not display any reports or folders!! what am I doing wrong please
> > help!!!
Showing posts with label msdn. Show all posts
Showing posts with label msdn. Show all posts
Tuesday, March 27, 2012
Forms authentication security
Forms Authentication Sample
I'm using the forms auth sample:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp
I've followed the steps in the sample for configuring forms auth on the
/Reports and /ReportServer webs.
Forms Auth now works fine on the /ReportServer web. However, on the Report
Manager app (/Reports web), even though I authenticate correctly (I debugged
and stepped through the code), it's not redirecting to the ReturnURL. It
simply returns to the logon screen.
Here's what I've done to the Report Manager web (according to the sample
instructions):
1 - Copy Microsoft.Samples.ReportingServices.CustomSecurity.dll and
Microsoft.Samples.ReportingServices.CustomSecurity.pdb to the
<install>\ReportManager\bin directory
2- In RSWebApplication.config file I've updated the UI element:
<UI>
<CustomAuthenticationUI>
<loginUrl>/Pages/UILogon.aspx</loginUrl>
<UseSSL>False</UseSSL>
</CustomAuthenticationUI>
<ReportServerUrl>http://<server>/ReportServer</ReportServerUrl>
</UI>
*** I set UseSSL to false because this is a development environment ***
3 - In rsmgrpolicy.config I changed the PermissionSetName attribute from
Execution to FullTrust as follows:
<CodeGroup
class="FirstMatchCodeGroup"
version="1"
PermissionSetName="FullTrust"
Description="This code group grants MyComputer code Execution
permission. ">
<IMembershipCondition
class="ZoneMembershipCondition"
version="1"
Zone="MyComputer" />
4 - In the Report manager web config file:
Disabled impersonation by locating the section <identity impersonate= "true"
/> and changing it to the following: <identity impersonate="false" />.
5 - Set the Report virtual directory to Anonymous authentication
6 - In the RSReportServer.config file. Locate the <Security> element and add
the previously registered user name as follows:
<Security>
<Extension Name="Forms"
Type="Microsoft.Samples.ReportingServices.CustomSecurity.Authorization,
Microsoft.Samples.ReportingServices.CustomSecurity" >
<Configuration>
<AdminConfiguration>
<UserName>username</UserName>
</AdminConfiguration>
</Configuration>
</Extension>
</Security>
***username was changed to the user I set up and should validate. ***
Note: I've made all the changes in the article with regards to the
/ReportServer web as well. And again, that web appears to be working OK.
Any idea why Forms Auth isn't working correctly on the Reports Manager web
app' Is there something else I need to do to the web.config file?Be sure to navigate to http://SERVERNAME/reports and not
http://localhost/reports. That's what got me for a while!|||Thank You !!!!
"s" <sjd0103@.comcast.net> wrote in message
news:Xns95D6A2E839377sjd0103aolcom@.207.46.248.16...
> Be sure to navigate to http://SERVERNAME/reports and not
> http://localhost/reports. That's what got me for a while!
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp
I've followed the steps in the sample for configuring forms auth on the
/Reports and /ReportServer webs.
Forms Auth now works fine on the /ReportServer web. However, on the Report
Manager app (/Reports web), even though I authenticate correctly (I debugged
and stepped through the code), it's not redirecting to the ReturnURL. It
simply returns to the logon screen.
Here's what I've done to the Report Manager web (according to the sample
instructions):
1 - Copy Microsoft.Samples.ReportingServices.CustomSecurity.dll and
Microsoft.Samples.ReportingServices.CustomSecurity.pdb to the
<install>\ReportManager\bin directory
2- In RSWebApplication.config file I've updated the UI element:
<UI>
<CustomAuthenticationUI>
<loginUrl>/Pages/UILogon.aspx</loginUrl>
<UseSSL>False</UseSSL>
</CustomAuthenticationUI>
<ReportServerUrl>http://<server>/ReportServer</ReportServerUrl>
</UI>
*** I set UseSSL to false because this is a development environment ***
3 - In rsmgrpolicy.config I changed the PermissionSetName attribute from
Execution to FullTrust as follows:
<CodeGroup
class="FirstMatchCodeGroup"
version="1"
PermissionSetName="FullTrust"
Description="This code group grants MyComputer code Execution
permission. ">
<IMembershipCondition
class="ZoneMembershipCondition"
version="1"
Zone="MyComputer" />
4 - In the Report manager web config file:
Disabled impersonation by locating the section <identity impersonate= "true"
/> and changing it to the following: <identity impersonate="false" />.
5 - Set the Report virtual directory to Anonymous authentication
6 - In the RSReportServer.config file. Locate the <Security> element and add
the previously registered user name as follows:
<Security>
<Extension Name="Forms"
Type="Microsoft.Samples.ReportingServices.CustomSecurity.Authorization,
Microsoft.Samples.ReportingServices.CustomSecurity" >
<Configuration>
<AdminConfiguration>
<UserName>username</UserName>
</AdminConfiguration>
</Configuration>
</Extension>
</Security>
***username was changed to the user I set up and should validate. ***
Note: I've made all the changes in the article with regards to the
/ReportServer web as well. And again, that web appears to be working OK.
Any idea why Forms Auth isn't working correctly on the Reports Manager web
app' Is there something else I need to do to the web.config file?Be sure to navigate to http://SERVERNAME/reports and not
http://localhost/reports. That's what got me for a while!|||Thank You !!!!
"s" <sjd0103@.comcast.net> wrote in message
news:Xns95D6A2E839377sjd0103aolcom@.207.46.248.16...
> Be sure to navigate to http://SERVERNAME/reports and not
> http://localhost/reports. That's what got me for a while!
Monday, March 26, 2012
Forms Authentication and Unattended Report Execution
I have implemented forms authentication security extension as described in the MSDN whitepaper "Using Forms Authentication in Reporting Services" and it works fine. However, I ran into problems trying to create scheduled execution snapshot for a report when it fails with unable to authenticate. How do I configure RS to authenticate for unattended execution with forms authentication?
Thanks,Please disregard this one. Stopping and restarting the ReportServerService resolved the issue.
Labels:
authentication,
database,
described,
execution,
extension,
forms,
implemented,
microsoft,
msdn,
mysql,
oracle,
report,
reporting,
security,
server,
services,
sql,
unattended,
whitepaper
Forms Authentication and Unattended Report Execution
I have implemented forms authentication security extension as described in the MSDN whitepaper "Using Forms Authentication in Reporting Services" and it works fine. However, I ran into problems trying to create scheduled execution snapshot for a report when it fails with unable to authenticate. How do I configure RS to authenticate for unattended execution with forms authentication?
Thanks,Please disregard this one. Stopping and restarting the ReportServerService resolved the issue.sql
Labels:
authentication,
database,
described,
execution,
extension,
forms,
implemented,
microsoft,
msdn,
mysql,
oracle,
report,
reporting,
security,
server,
services,
sql,
unattended,
whitepaper
Subscribe to:
Posts (Atom)