Groups | Blog | Home
all groups > sql server reporting services > september 2004 >

sql server reporting services : Report Authentication


Prem
9/21/2004 4:09:08 PM
This is a newbie question. I have the report viewer component on one of my
aspx pages. When the user tries to open this page, he/she is prompted with a
user/password on the server. How do I set up the reporting services so that
it uses a generic account for all requests from the web. Thanks.

Prem
Teo Lachev
9/21/2004 9:13:50 PM
Well, the wrong way is to turn on Anonymous access to the Report Server. The
proper way is to create a custom security extension to replace the default
Windows-based security.

--
Hope this helps.

-----------------------------------------------------
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
-----------------------------------------------------

[quoted text, click to view]

Nell
9/22/2004 6:07:03 AM
You need to grant permissions to your users and groups on the report server.
You can do this at 'http://servername/reports', select the folder you want to
apply permissions to, then select 'properties' and 'security'. Check out this
article on Ode to Code for more info.

http://odetocode.com/Articles/215.aspx

You need to give browse access to the accounts you want to be able to view
your reports, if you're using anonymous access then you need to make sure
that the user you have set up in IIS for anonymous access (usually
IUSR_computername or IWAM_computername) has this level of access. Don't
give this account any unnecessary permissions though!

[quoted text, click to view]
AddThis Social Bookmark Button