Wednesday, March 7, 2012

Problem using Windows Authentication

Hello,
I have just installed Reporting Services and was able to figure out
pretty much everything, with the exception of using Windows
Authentication.
As I am an administrator on the machine on which Reporting Services is
running, I am able to successfully log in. However, no other accounts
are able to gain access even though these accounts are in the same
domain as the machine. Other people are simply prompted for a
username/password, and are denied access.
At first I thought that this was an issue with the way the
application's users were configured. I added a few accounts to tha
application via the Reporting Service's web interface and assigned
some roles. However, the same problem persists.
When I enable anonymous access to the application via IIS, everyone is
able to log in, so I know that the application is at least
accessible. Unfortunatly, anonymous access is not a viable option.
I readily admit that I am a novice, and I would not be surprised to
find that I have overlooked a simple configuration issue somewhere.
Please help!
Thanks,
tcbThey should not be getting prompted. First, does the machine running RS
using a fixed IP address?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"baker2g" <tcbakes@.gmail.com> wrote in message
news:1187038113.665332.22320@.x40g2000prg.googlegroups.com...
> Hello,
> I have just installed Reporting Services and was able to figure out
> pretty much everything, with the exception of using Windows
> Authentication.
> As I am an administrator on the machine on which Reporting Services is
> running, I am able to successfully log in. However, no other accounts
> are able to gain access even though these accounts are in the same
> domain as the machine. Other people are simply prompted for a
> username/password, and are denied access.
> At first I thought that this was an issue with the way the
> application's users were configured. I added a few accounts to tha
> application via the Reporting Service's web interface and assigned
> some roles. However, the same problem persists.
> When I enable anonymous access to the application via IIS, everyone is
> able to log in, so I know that the application is at least
> accessible. Unfortunatly, anonymous access is not a viable option.
> I readily admit that I am a novice, and I would not be surprised to
> find that I have overlooked a simple configuration issue somewhere.
> Please help!
> Thanks,
> tcb
>|||On Aug 13, 1:57 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> They should not be getting prompted. First, does the machine running RS
> using a fixed IP address?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "baker2g" <tcba...@.gmail.com> wrote in message
> news:1187038113.665332.22320@.x40g2000prg.googlegroups.com...
>
> > Hello,
> > I have just installed Reporting Services and was able to figure out
> > pretty much everything, with the exception of using Windows
> > Authentication.
> > As I am an administrator on the machine on which Reporting Services is
> > running, I am able to successfully log in. However, no other accounts
> > are able to gain access even though these accounts are in the same
> > domain as the machine. Other people are simply prompted for a
> > username/password, and are denied access.
> > At first I thought that this was an issue with the way the
> > application's users were configured. I added a few accounts to tha
> > application via the Reporting Service's web interface and assigned
> > some roles. However, the same problem persists.
> > When I enable anonymous access to the application via IIS, everyone is
> > able to log in, so I know that the application is at least
> > accessible. Unfortunatly, anonymous access is not a viable option.
> > I readily admit that I am a novice, and I would not be surprised to
> > find that I have overlooked a simple configuration issue somewhere.
> > Please help!
> > Thanks,
> > tcb- Hide quoted text -
> - Show quoted text -
Thanks for the response!
I don't think that the machine is using a fixed IP addresss. I have
deployed RS on my local box and have had people test it by using my IP
address (http://<ipaddress>/Reports). Although the IP address is not
static, it does not change frequently and should be fine while I am
playing aroung with RS. People were able to access the app when
anonymous access was turned on, so I know that people can access the
RS app when authentication is removed from the equation.
Thanks,
tcb|||I had a weird issue with a server of mine where it would prompt for username
and password when it should not have. The issue went away once I gave it a
fixed IP address. As far as anonymous working, well when anonymous it
doesn't care who you are so it is not doing the same actions.
If you can give it a fixed IP address and at least see if your being
prompted goes away.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"baker2g" <tcbakes@.gmail.com> wrote in message
news:1187040249.518255.134720@.j4g2000prf.googlegroups.com...
> On Aug 13, 1:57 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> They should not be getting prompted. First, does the machine running RS
>> using a fixed IP address?
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "baker2g" <tcba...@.gmail.com> wrote in message
>> news:1187038113.665332.22320@.x40g2000prg.googlegroups.com...
>>
>> > Hello,
>> > I have just installed Reporting Services and was able to figure out
>> > pretty much everything, with the exception of using Windows
>> > Authentication.
>> > As I am an administrator on the machine on which Reporting Services is
>> > running, I am able to successfully log in. However, no other accounts
>> > are able to gain access even though these accounts are in the same
>> > domain as the machine. Other people are simply prompted for a
>> > username/password, and are denied access.
>> > At first I thought that this was an issue with the way the
>> > application's users were configured. I added a few accounts to tha
>> > application via the Reporting Service's web interface and assigned
>> > some roles. However, the same problem persists.
>> > When I enable anonymous access to the application via IIS, everyone is
>> > able to log in, so I know that the application is at least
>> > accessible. Unfortunatly, anonymous access is not a viable option.
>> > I readily admit that I am a novice, and I would not be surprised to
>> > find that I have overlooked a simple configuration issue somewhere.
>> > Please help!
>> > Thanks,
>> > tcb- Hide quoted text -
>> - Show quoted text -
> Thanks for the response!
> I don't think that the machine is using a fixed IP addresss. I have
> deployed RS on my local box and have had people test it by using my IP
> address (http://<ipaddress>/Reports). Although the IP address is not
> static, it does not change frequently and should be fine while I am
> playing aroung with RS. People were able to access the app when
> anonymous access was turned on, so I know that people can access the
> RS app when authentication is removed from the equation.
> Thanks,
> tcb
>

No comments:

Post a Comment