I created a report in VS.NET for SQL Server Reporting Services. The Report Manager is an ASP.NET webpage. When I tried to open the Report Manager, I got an error message (see below).

Most of the posts that I see on the web for this subject suggest mondifying the permissions to the folder. I modified the permissions to allow everyone full control of the MSSQL folder, but that didn't work. Other posts mentioned granting rights to an ASP user group. I don't have one, so I'm not sure if that's what I need to do.

Anyone have any ideas on how to clear this up.

Chris

Server Error in '/Reports' Application.
--------------------------------------------------------------------------------

Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\bin" is denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.UnauthorizedAccessException: Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\bin" is denied.

ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user.

To grant ASP.NET write access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[UnauthorizedAccessException: Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\bin" is denied.]
   System.IO.__Error.WinIOError(Int32 errorCode, String str) +393
   System.IO.Directory.InternalGetFileDirectoryNames( String fullPath, String userPath, Boolean file) +229
   System.IO.Directory.InternalGetDirectories(String path, String userPath, String searchPattern) +24
   System.IO.Directory.GetDirectories(String path, String searchPattern) +477
   Microsoft.ReportingServices.Diagnostics.Localizati on.GetInstalledCultures()
   Microsoft.ReportingServices.Diagnostics.Localizati on..cctor()

[TypeInitializationException: The type initializer for "Microsoft.ReportingServices.Diagnostics.Localizat ion" threw an exception.]
   Microsoft.ReportingServices.Diagnostics.Localizati on.SetCultureFromPriorityList(String[] localeList) +0
   Microsoft.ReportingServices.UI.GlobalApp.Applicati on_BeginRequest(Object sender, EventArgs e)
   System.Web.SyncEventExecutionStep.System.Web.HttpA pplication+IExecutionStep.Execute() +59
   System.Web.HttpApplication.ExecuteStep(IExecutionS tep step, Boolean& completedSynchronously) +87




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

Hello,

You need to give the account {MACHINE}\ASPNET, or the IUSR_MACHINENAME account when <identity impersonate="true"/>, permissions to the C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\bin folder.

Brian

Hello, I am getting the exact same error as g_rhymes. I have granted Full Control permissions for the IUSR_Computername account on the BIN directory and have also ensured that this is the account used for Anonymous Access on this directory in IIS. The IIS properties has Read and Script and Executables can be run.

This is all run on a W2K server. The SQL database is on the same server as SQL Reports and IIS. We do not have any ASPNET accounts (I assume these are only needed for 2003). SQL Reports Designer is not installed as it requires Visual Studio .net 2003.

You must have an ASPNET account on the machine- otherwise you didn't install .NET framework properly (or at all).


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

I tried to use bmains advice. I went to the C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\bin folder in windows explorer and added permissions for IUSR_MACHINENAME (granted full control). That didn't work.

I didn't understand the part about "when <identity impersonate="true"/>". I'm assuming that's code in an asp page, but I didn't see any asp pages in the bin directory.

I did something similar to Zeawater. I zapped a server and installed Windows 2000 Server on it. I ran dcpromo to make the server a domain controller (with DNS as the only networking option on the server). I installed SQL Server 2000, installed the SQL Server 2000 service pack 3a, installed Visual Studio .NET, and install SQL Server Reporting Services. When I went to open reporting services, I got an internet connection wizard. Wasn't sure about the poxy settings (checked automatically detect settings). After setting up the internet connect, still got the access denied error message.

If anyone has any ideas, I would be greatly appreciate any suggestions.

Thanks!

Chris

GOT IT TO WORK.

The problem happens when installing RS on Windows 2000 Server that is a domain controller. RS doesn't do the setup correctly. The basic steps to fix the problem are

1. Grant impersonate privilege to IWAM_<machine> account (see knowledge base article 824308). Go to domain controller security policy in administrative tools. Click security settings -> Click local policies -> click user right assignment. In the right pane, double click impersonate a client after authentication. In security policy setting window, click define these policy settings. Click add -> click browse. In select users or groups window, select IWAM account name and click add. Then, click Ok -> Click OK -> Click OK. At command prompt, type the following command: secedit /refreshpolicy machine_policy /enforce. Then, type iisreset.

2. Remove IWAM_<machine> account from guest group. Go to active directory users and computers in administrative tools. Open users folder. In right pane, double click IWAM_<machine>. Select member of tab. Remove guest. Click OK.

3. Reboot.

4. Run rsactivate. From command prompt, change directory to C:\Program Files\Microsoft SQL Server\80\Tools\Binn. The run following command: RSActivate.exe -c "c:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config" -t.

See the following link for more details http://msdn.microsoft.com/library/de...rs_v1_8k82.asp .

For now, this seems to have fixed this problem.

Chris