Issue 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!
--
SaravananOne 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.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
news:84A3066B-05BB-4360-8A8E-DCE0DFF6E50D@.microsoft.com...
> 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!
> --
> Saravanan|||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?
--
Saravanan
"Bruce L-C [MVP]" wrote:
> 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.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> news:84A3066B-05BB-4360-8A8E-DCE0DFF6E50D@.microsoft.com...
> > 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!
> > --
> > Saravanan
>
>|||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).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
news:5A61A957-3E8B-464D-8E0F-D1DD886ADA39@.microsoft.com...
> 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?
> --
> Saravanan
>
> "Bruce L-C [MVP]" wrote:
>> 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.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
>> news:84A3066B-05BB-4360-8A8E-DCE0DFF6E50D@.microsoft.com...
>> > 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!
>> > --
>> > Saravanan
>>|||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!
--
Saravanan
"Bruce L-C [MVP]" wrote:
> 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).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> news:5A61A957-3E8B-464D-8E0F-D1DD886ADA39@.microsoft.com...
> > 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?
> > --
> > Saravanan
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> 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.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> >> news:84A3066B-05BB-4360-8A8E-DCE0DFF6E50D@.microsoft.com...
> >> > 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!
> >> > --
> >> > Saravanan
> >>
> >>
> >>
>
>|||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.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
news:7FF767C5-2371-4CFB-BAD9-120049766893@.microsoft.com...
> 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!
> --
> Saravanan
>
> "Bruce L-C [MVP]" wrote:
>> 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).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
>> news:5A61A957-3E8B-464D-8E0F-D1DD886ADA39@.microsoft.com...
>> > 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?
>> > --
>> > Saravanan
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> 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.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
>> >> news:84A3066B-05BB-4360-8A8E-DCE0DFF6E50D@.microsoft.com...
>> >> > 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!
>> >> > --
>> >> > Saravanan
>> >>
>> >>
>> >>
>>|||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
--
Saravanan
"Bruce L-C [MVP]" wrote:
> 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.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> news:7FF767C5-2371-4CFB-BAD9-120049766893@.microsoft.com...
> > 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!
> > --
> > Saravanan
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> 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).
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> >> news:5A61A957-3E8B-464D-8E0F-D1DD886ADA39@.microsoft.com...
> >> > 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?
> >> > --
> >> > Saravanan
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> 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.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> >> >> news:84A3066B-05BB-4360-8A8E-DCE0DFF6E50D@.microsoft.com...
> >> >> > 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!
> >> >> > --
> >> >> > Saravanan
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||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.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
news:0C759E42-7D5E-4CD0-872E-E7F1619884DE@.microsoft.com...
> 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
> --
> Saravanan
>
> "Bruce L-C [MVP]" wrote:
>> 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.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
>> news:7FF767C5-2371-4CFB-BAD9-120049766893@.microsoft.com...
>> > 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!
>> > --
>> > Saravanan
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> 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).
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >>
>> >> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
>> >> news:5A61A957-3E8B-464D-8E0F-D1DD886ADA39@.microsoft.com...
>> >> > 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?
>> >> > --
>> >> > Saravanan
>> >> >
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> 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.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
>> >> >> news:84A3066B-05BB-4360-8A8E-DCE0DFF6E50D@.microsoft.com...
>> >> >> > 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!
>> >> >> > --
>> >> >> > Saravanan
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||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
--
Saravanan
"Bruce L-C [MVP]" wrote:
> 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.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> news:0C759E42-7D5E-4CD0-872E-E7F1619884DE@.microsoft.com...
> > 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
> > --
> > Saravanan
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> 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.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> >> news:7FF767C5-2371-4CFB-BAD9-120049766893@.microsoft.com...
> >> > 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!
> >> > --
> >> > Saravanan
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> 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).
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> >> >> news:5A61A957-3E8B-464D-8E0F-D1DD886ADA39@.microsoft.com...
> >> >> > 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?
> >> >> > --
> >> >> > Saravanan
> >> >> >
> >> >> >
> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >
> >> >> >> 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.
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> Bruce Loehle-Conger
> >> >> >> MVP SQL Server Reporting Services
> >> >> >>
> >> >> >> "Saravanan" <Saravanan@.discussions.microsoft.com> wrote in message
> >> >> >> news:84A3066B-05BB-4360-8A8E-DCE0DFF6E50D@.microsoft.com...
> >> >> >> > 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!
> >> >> >> > --
> >> >> >> > Saravanan
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||> > > 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.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rowen" <rowenmcd@.gmail.com> wrote in message
news:1170200769.300637.219980@.h3g2000cwc.googlegroups.com...
>> > > 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
>|||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
--
Saravanan
"Bruce L-C [MVP]" wrote:
> 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.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rowen" <rowenmcd@.gmail.com> wrote in message
> news:1170200769.300637.219980@.h3g2000cwc.googlegroups.com...
> >
> >> > > 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
> >
>
>|||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
> without Admin priveliges on the report server machine.
> Again! Thanks a lot
> --
> Saravanan
> "Bruce L-C [MVP]" wrote:
> > 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.
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> > "Rowen" <rowen...@.gmail.com> wrote in message
> >news:1170200769.300637.219980@.h3g2000cwc.googlegroups.com...
> > >> > > 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
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