SQL Server Performance

SQL Server Report Services Configuring Issue

Discussion in 'SQL Server 2005 Reporting Services' started by dineshasanka, Jun 13, 2007.

  1. dineshasanka Moderator

    SQL Server 2005 Sp2

    Windows Server 2003 Sp2

    When i open the Reporting Services Configuration Manager on our newly installed SQL 2005 box i get a red X on "Web Service Identity".

    The window in question states that "The Web Service runs under the ASP .NET Machine account under IIS 5 or ..." with what looks to be a text entry box that is grayed out with the label "ASP .NET Service Account. The text entry box that is grayed out is blank.

    When the Apply button is pressed a Task Status box opens at the bottom that states "There was an error setting the identity for the web service. The previously set identity will still be used."

    When the option for "Tell me more about the problem and how to resolve it." is pressed i get a dialog box that has two lines of text reading:

    "ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occured in the WMI provider. Error Code 80070005"

    "at Report ServicesConfigUI.RSReportSErverAdmin.SetWebServiceIdentity(StringapplicationPool)"



    I have the same question ashttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=295080&SiteID=1

    but the difference is I my operation system is windows 2003.


    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  2. satya Moderator

    As per that post:
    ...in the %installPath%Reporting ServicesReportServer directory there is a file called rsreportserver.config ... grant the account machinenameASPNET access to this file...


    Can you check whether the ASP.NET account has relevant privileges on the directory and file.

    Alsohttp://technet.microsoft.com/en-us/library/ms189361.aspx fyi (may be you have gone through it already).

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  3. dineshasanka Moderator

    it has maximum permission that folder and file

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  4. dineshasanka Moderator

    managed to fixe this by recreating Report server and report manager virtual directories

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/

Share This Page