Report Server Windows Service (MSSQLSERVER) has not been granted access to the catalog content. RRS feed

  • Question


    I ran SP2 on my development SQL and now can no longer access Reporting Services.

    I'm running Windows XP as a host machine which is running an instance of SQL Server Dev.

    On Virtual Server running Windows 2003, being hosted on the XP machine.


    I get the error in my subject line in Event Viewer on both XP and Virtual Win 2003.


    I can use DTCping from XP to Virtual Win2003 - output is RPC successful  Please start Ping from Win2003 to complete test

    DTCping fails from Virtual Win2003 to XP ==>Problem:fail to invoke remote RPC method
    Error(0x5) at dtcping.cpp @303
    -->RPC pinging exception
    -->5(Access is denied.)
    RPC test failed

    I can run ping by NetBIOS name from both machines.

    Verfied =>TurnOffRpcSecurity value is 1




    Monday, November 5, 2007 4:29 PM