 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Services / Reporting Services / January 2007Issue in Domain User Accessing Report
Hello All, I have created Reporting Services Report and I had given a user Browser permissions to browse the report. But he is not able to get to the report. The browser asks for userid and password and when typed it does not take it. Only when I put the user in the local administrator group, the user is able to see the report and all the reports. I checked the app pool and it is running under network service and the network service is in the local administrator group. Could anybody help? Thanks!  SignatureSaravanan One thing you could try (and really is easier than adding user by user browser permissions). Create a local group (I called mine Reports). Add all users and groups of users to this report. Then add this group to the browser role of Home. Everything inherits permissions from the Home directory. SignatureBruce Loehle-Conger MVP SQL Server Reporting Services > Hello All, > I have created Reporting Services Report and I had given a user Browser [quoted text clipped - 10 lines] > > Thanks! Thanks Bruce for your response. I am starting to test with a user now and that I would be putting the users in groups and assign permissions to the group. My concern is that, whether the users needs to be on the local admin group?. Am I missing anything? SignatureSaravanan > One thing you could try (and really is easier than adding user by user > browser permissions). Create a local group (I called mine Reports). Add all [quoted text clipped - 15 lines] > > > > Thanks! No, definitely not. Do not put the user in the local admin group. I think what you are missing is the process of adding to a role. Click on the home directory, details, security (on the left panel). Then add a role and use the new group that you have and give it browsing rights). SignatureBruce Loehle-Conger MVP SQL Server Reporting Services > Thanks Bruce for your response. I am starting to test with a user now and > that I would be putting the users in groups and assign permissions to the [quoted text clipped - 26 lines] >> > >> > Thanks! Thanks for the patience to answer me Bruce. Before adding into the local administrators group, I tried that option too. I included the group onto the Browser Role on the Home of Reporting Services, then created the folder and I selected assign specific rights to the folder I uploaded the reports , went to the security tab of the folder and included the group into the Browser Role. As it did not work, I included the group into local admin. Thanks! SignatureSaravanan > No, definitely not. Do not put the user in the local admin group. I think > what you are missing is the process of adding to a role. Click on the home [quoted text clipped - 31 lines] > >> > > >> > Thanks! When you assigned specific rights to the folder you overwrote the inherited rights to Home. All the folders inherit from Home. First, try and get this working without doing anything to the new folder. Do this: 1. Add a user to a local group 2. Can they see Home (even if you don't have any folders) 3. Add a folder 4. Can they see this folder? 5. Add a report to the folder. Again, don't touch any of the rights on the folder you should have to. The only time to do this is if you want them in some folders and not others. In that case you can give browsing rights to the folder and not to home and then a link that brings them directly to the folder in question. SignatureBruce Loehle-Conger MVP SQL Server Reporting Services > Thanks for the patience to answer me Bruce. > [quoted text clipped - 53 lines] >> >> > >> >> > Thanks! Hi Bruce, Thanks for the step by step instructions. This is what I did 1. Created a Usergroup named ReportUsers 2. Included a Domain User into it (who does not have any access on the machine) 3. I went to the Reporting services home and selected Properties > Security and provided this group a role of Browser 4. I asked the user to go into the home page as http://machinename/reports/Pages/Folder.aspx 5. The user is prompted with the a userid and password dialog box with the machinename.domain.com in the dialog box above the userid text box. Please let me know, if this makes sense. Thanks for your support SignatureSaravanan > When you assigned specific rights to the folder you overwrote the inherited > rights to Home. All the folders inherit from Home. First, try and get this [quoted text clipped - 68 lines] > >> >> > > >> >> > Thanks! When prompted can they do this: domainname\username put into the userid box and then their password? I had this happen to me before and tore my hair out resolving it. For me the issue was that the server did not have a fixed IP address, it was using DHCP. Once I made it a fixed IP address then the problem went away. SignatureBruce Loehle-Conger MVP SQL Server Reporting Services > Hi Bruce, > Thanks for the step by step instructions. This is what I did [quoted text clipped - 102 lines] >> >> >> > >> >> >> > Thanks! Hi Bruce, Thanks for your ideas. Even if they put their Domain userid and password it is not letting them in. I checked the IP configuration and I can see that the IP has been assigned static SignatureSaravanan > When prompted can they do this: > domainname\username put into the userid box and then their password? [quoted text clipped - 109 lines] > >> >> >> > > >> >> >> > Thanks! > > > 5. The user is prompted with the a userid and password dialog box with the > > > machinename.domain.com in the dialog box above the userid text box. This sounds to me like it is related to permissions required to access the report manager website (permissions set in IIS) rather than permissions to access the reports via report manager. You may need to give the user/group permission to read the actual folder where the report server website is installed (should be similar to 'C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\'). Check to ensure the user has these privileges. Rowen Unless IIS permissions have been changed from outside of RS there is never a need to do anything with IIS permissions. However, if anyone has been changing permissions with IIS then there could be a problem with a mismatch between the two. SignatureBruce Loehle-Conger MVP SQL Server Reporting Services >> > > 5. The user is prompted with the a userid and password dialog box >> > > with the [quoted text clipped - 9 lines] > > Rowen Thanks Rowen and Bruce. No body changed the permissions on the server, but when I followed Rowen's idea it worked. Now the users are able see the report without Admin priveliges on the report server machine. Again! Thanks a lot SignatureSaravanan > Unless IIS permissions have been changed from outside of RS there is never a > need to do anything with IIS permissions. However, if anyone has been [quoted text clipped - 14 lines] > > > > Rowen On Feb 1, 5:32 am, Saravanan <Sarava...@discussions.microsoft.com> wrote: > Thanks Rowen and Bruce. No body changed the permissions on the server, but > when I followed Rowen's idea it worked. Now the users are able see the report [quoted text clipped - 26 lines] > > > > Rowen Glad to hear this solved the problem. It may have been there since reporting services was installed (particularly when using reporting services 2003, which often requires manual configuration after installation). Rowen |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.