User Access
in [Reports]
|
Prev: Projects wont open after a few days
Next: Removing aggregate information from the matrix data region
From: richard on 26 Jun 2008 12:25 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.
From: Bruce L-C [MVP] on 26 Jun 2008 13:10 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. -- Bruce Loehle-Conger MVP SQL Server Reporting Services "richard" <cftung(a)dynamicbiz.com.my> wrote in message news:51CA1166-9B2C-4D4D-8954-4779CED26078(a)microsoft.com... > 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.
From: richard on 28 Jun 2008 10:59 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? "Bruce L-C [MVP]" <bruce_lcNOSPAM(a)hotmail.com> wrote in message news:OKPPV%2361IHA.5728(a)TK2MSFTNGP06.phx.gbl... > 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. > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > > "richard" <cftung(a)dynamicbiz.com.my> wrote in message > news:51CA1166-9B2C-4D4D-8954-4779CED26078(a)microsoft.com... >> 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. > >
From: ITDUDE27 on 18 Jul 2008 11:07
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. "richard" wrote: > 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? > > "Bruce L-C [MVP]" <bruce_lcNOSPAM(a)hotmail.com> wrote in message > news:OKPPV%2361IHA.5728(a)TK2MSFTNGP06.phx.gbl... > > 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. > > > > -- > > Bruce Loehle-Conger > > MVP SQL Server Reporting Services > > > > > > "richard" <cftung(a)dynamicbiz.com.my> wrote in message > > news:51CA1166-9B2C-4D4D-8954-4779CED26078(a)microsoft.com... > >> 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. > > > > > |