Login box displayed when browsing to ReportServer

Hi,
I have RS and SQL Server on the same development box. When I browse to
http://localhost/ I can see my reports on my box. However, when other
users browse to my machine with http://mymachinename/ they get a Windows
Login box pop up. When they type in their Windows Credentials, the box
pops up again. If they click cancel, they get "You are not authorized to
view this page."
How should I configure IIS to get this working? I've never used IIS or
Reporting Services before.
Thanks.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.htmlIt sounds like a permissions issue. Try enabling anonymous access for the
website, and make sure that the virtual directories that IIS is using have
the proper permissions (at least read perms for the IIS account).
"Mark Allison" wrote:
> Hi,
> I have RS and SQL Server on the same development box. When I browse to
> http://localhost/ I can see my reports on my box. However, when other
> users browse to my machine with http://mymachinename/ they get a Windows
> Login box pop up. When they type in their Windows Credentials, the box
> pops up again. If they click cancel, they get "You are not authorized to
> view this page."
> How should I configure IIS to get this working? I've never used IIS or
> Reporting Services before.
> Thanks.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>|||Thanks Aaron, yes definitely a perms issue. This is how things are set up:
The error the user sees (different now from my earlier post):
http://tinyurl.com/58mty
IIS
===Authentication methods
http://tinyurl.com/46btf
Default web site properties
http://tinyurl.com/6l9ch
Reporting Services
==================RS Data sources
http://tinyurl.com/5wd78
RS Execution
http://tinyurl.com/3lqlq
RS Security
http://tinyurl.com/4p98j
Reporting Services, IIS and the SQL Server where the Reports database is
located are all on the box.
Thanks for looking into this.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Aaron Z wrote:
> It sounds like a permissions issue. Try enabling anonymous access for the
> website, and make sure that the virtual directories that IIS is using have
> the proper permissions (at least read perms for the IIS account).
> "Mark Allison" wrote:
>
>>Hi,
>>I have RS and SQL Server on the same development box. When I browse to
>>http://localhost/ I can see my reports on my box. However, when other
>>users browse to my machine with http://mymachinename/ they get a Windows
>>Login box pop up. When they type in their Windows Credentials, the box
>>pops up again. If they click cancel, they get "You are not authorized to
>>view this page."
>>How should I configure IIS to get this working? I've never used IIS or
>>Reporting Services before.
>>Thanks.
>>--
>>Mark Allison, SQL Server MVP
>>http://www.markallison.co.uk
>>Looking for a SQL Server replication book?
>>http://www.nwsu.com/0974973602m.html|||I've resolved this myself by using a standard SQL Login.
Thanks for your time.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Mark Allison wrote:
> Thanks Aaron, yes definitely a perms issue. This is how things are set up:
> The error the user sees (different now from my earlier post):
> http://tinyurl.com/58mty
> IIS
> ===> Authentication methods
> http://tinyurl.com/46btf
> Default web site properties
> http://tinyurl.com/6l9ch
>
> Reporting Services
> ==================> RS Data sources
> http://tinyurl.com/5wd78
> RS Execution
> http://tinyurl.com/3lqlq
> RS Security
> http://tinyurl.com/4p98j
>
> Reporting Services, IIS and the SQL Server where the Reports database is
> located are all on the box.
> Thanks for looking into this.
>