User Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

richard - 26 Jun 2008 17:25 GMT

We have deploy the sql reporting in the server. When user browse from thier
machine, it will prompt user to enter server userid and password.

Therefore, we decided to mark the checkbox as anonymois Authentication so it
won;t prompt user to enter the username and password. After we done that, we
having the error message "user does not have enough permission".
May i know what the rights i should given in order to allow user to access
it?

Beside this, there is anyway to directly turn out the pdf format in the
report viewer for the user? Rather than user have to convert manually.

Reply to this Message

Bruce L-C [MVP] - 26 Jun 2008 18:10 GMT

Several things. Anonymous is not a good idea. This is what will happen. When
you are anonymous everyone (including people who are admins) are anonymous.
So all of the normal options in Report Manager that should be there are not
because you are anonymous.

You should not be getting prompted for the userid and password. Does this
happen just to see the list of reports or does it occur when you try to run
a report. I am assuming that you are in a domain. Now, when you have Server
2003 with enhanced IE security you will be prompted but I doubt that is what
is happening for you.

The only way to have pdf is if you have your own front end website. There is
no way for Report Manager to do this for you.

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> We have deploy the sql reporting in the server. When user browse from
> thier machine, it will prompt user to enter server userid and password.
[quoted text clipped - 7 lines]
> Beside this, there is anyway to directly turn out the pdf format in the
> report viewer for the user? Rather than user have to convert manually.

Reply to this Message

richard - 28 Jun 2008 15:59 GMT

So i have setup the report security by add in the usergroup in the security
and the report won't prompt for username and password. It is what you means?

Besides this, how can i control the user to view certain report in the
folder by setup the report security?

> Several things. Anonymous is not a good idea. This is what will happen.
> When you are anonymous everyone (including people who are admins) are
[quoted text clipped - 21 lines]
>> Beside this, there is anyway to directly turn out the pdf format in the
>> report viewer for the user? Rather than user have to convert manually.

Reply to this Message

ITDUDE27 - 18 Jul 2008 16:07 GMT

Hi Richard,

Did you ever get the second part of your issue addressed, I have same issue
relating to who can see what report, right now they're all visible.

Please let me know if you got it fixed.

Thanks in advance.

> So i have setup the report security by add in the usergroup in the security
> and the report won't prompt for username and password. It is what you means?
[quoted text clipped - 27 lines]
> >> Beside this, there is anyway to directly turn out the pdf format in the
> >> report viewer for the user? Rather than user have to convert manually.

Reply to this Message