MS SQL Reporting Services - Permission error when users go to site.
Posted on 2006-10-25
I have a SQL 2005 Reporting Server. Users are unable to view the home page and therefore no reports are available.
I have alrready goine into the SRS configuration and enabled Domain Users the browser right. When users get to the site they get a password prompt. When they enter Domain\User and pasword, they stil do not get in. Error 401.3 is displayed on pages.
In IIS seucrity is set to use Windows Auth.
users PC has the internal server listed in the Intranet sites. I thought this would stop the authentication request and pass the current user on to the IIS Intranet SRS box.
On Reports home, Domain USers has browser rights.
Error when user goes to site:
HTTP Error 401.3 - Unauthorized: Access is denied due to an ACL set on the requested resource.
Internet Information Services (IIS)