Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajan.nithin
Starting Member
42 Posts |
 Posted - 2011-07-21 : 07:24:32
|
| Hi,Let me explain the scenario. We are using SSRS 2008 R2 for Reporting Services. It is currently configured with Windows authentication.When I click on the Report Server Link , it prompts to enter the Username & Password. When I enter Windows credentials I can access the reports.Now My boss wants to add Report Server Link to our website. When We click on the link The Reports should be visible. Since it is configured with Windows authentication. I need to enter the Windows credentials to access the reports. Since to login to the website we already go through an authentication process, we want to avoid the second level authentication to access reports.How can I configure in Reporting Services Configuration Manager so that user once logged into the website can directly access the reports without the authentication.Regards,Nithin |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-07-21 : 07:26:57
|
| seems like what you need is to add application role in your db and map datasources to the role. then assign all your user ids to that.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
rajan.nithin
Starting Member
42 Posts |
Posted - 2011-07-21 : 07:53:30
|
Thanks for the Reply. Since I am new to Sql Server ,I have very little knowledge on security settings. Is there any documentation/books which will help me implementing your solution.quote:
Originally posted by visakh16
seems like what you need is to add application role in your db and map datasources to the role. then assign all your user ids to that.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
|
|
|
|
|
|
|
Issue with Reporting Services Configuration Manage