SQL Server 2008 Report Server Issue

  • I am having trouble getting the Report Server to come online. I have everything set up correctly in the config using my local service as the "Service Account". When I first tried to access it, IE shot an "Unauthorized User" message. I had just clicked past the login prompt. So, I put my computerName\myUser Account for the User Name, and now I get a "Provider type not found" message. I just set it up last night so I haven't dug into it yet.

    I am using Vista Ultimate with IIS6 installed and IE6

    Any thoughts?

    UPDATE: I've granted ASP.NET permissions to the folder by using the LOCAL SERVICE, MY SPECIFIC ACCOUNT, and the LOCAL SYSTEM. All with no luck. It still gives me an

    "Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

    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 is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

    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 , the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user.

    To grant ASP.NET 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." message

  • Vista is IIS 7 not IIS 6 but you need to configure IIS 7 in IIS 6 mode and enable all the features needed to run Asp.net. Check the links below and make the relevant changes in your IIS 7 configurations.

    http://www.rickglos.com/post/2008/07/SQL-Server-Reporting-Services-unable-to-connect-to-the-localhost-on-Vista.aspx

    http://blogs.msdn.com/webdevtools/archive/2006/09/18/developing-web-applications-on-windows-vista-with-visual-studio-2005.aspx

    Kind regards,
    Gift Peddie

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply