I'm trying to use SSRS for the first time. I probably should do all of this on Server 2008, MSSQL 2008 and VS 2008 but I can't right now. Thus, I have XP Professional, MSSQL 2005 and VS 2005.
I have created a report within Visual Studio and I am attempting to publish it. I have configured the Report Server (see picture below). However, I can not publish the report or get access to the following URL:
The Report Server is of course local. The error I get from the Browser is:
HTTP 401.3 - Access denied by ACL on resource
Internet Information Services
... and the error I get from Visual Studio when I attempt to Publish is the same. In either attempt I am prompted to log in. Notice in the picture below showing the Windows Service Identity, I have successfully assigned my System/Windows logon.
This same logon is assigned to the ReportServer Database within SQL Server Management Studio. It is assigned as the default database !
Therefore, my questions:
1) why on earth would I not be able to Publish the report or access the ReportServer URL?
2) Is there some object level permission within SQL Server Management Studio I need to assign?
3) Should the ACL able to be modified to correct this and how?
4) Is the ASPNET user the one actually executing
The Web Service runs under the ASP .NET machine account (server_name\ASPNET) under IIS 5 or under the context of an application pool ...
I have also looked under DCOM CONFIG at the NETMAN properties and everything looks right there.
What then is it?