none
rsAceessDenied error for local administrator with SQL server 2012 Reporting services

    Question

  • Hi,

    I'm the local administrator of the PC and I have installed and configured the SQL server reporting services. But when I try to access the report manager web site I get an error saying that

    The permissions granted to user 'MalolanPC\Malolan' are insufficient for performing this operation. (rsAccessDenied). In fact MalolanPC\Malolan is the local administrator account. I have tried the following things

    1) Tried adding the SSRS URL to trusted web site

    2) Launched the IE10 as administrator and tried navigating to the site

    3) reduced the UAC level and tried again.

    But all efforts are in vain. I have seen may blogs. I need to set up this work on my PC. I use Windows 8 Pro 32 bit and SQL server 2012 developer edition


    Venkatesh. S|MCTS(WCF, ADO.NET 3.5)|eMail: heman_1978@hotmail.com

    Sunday, June 02, 2013 2:56 AM

All replies

  • Hi VenkateshSrini_CHN,

    You need to run the internet explorer with "Run as administrator"  and then try to run the url.

    To run the IE in "Run as adminisrtrator mode", Right click the IE Icon and click "Run as administrator".

    If the url  (http://[mycomputername]:80/Reports)  work fine, then please add your local user to the role setting for report manager.

    If this does not work for you try steps mentioned in the msdn forum:  http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/92f0de07-66b0-4d91-a4af-b5443e05c219

    Regards

    Harsh


    Regards Harsh

    Sunday, June 02, 2013 9:30 AM
  • Hi Harsh,

    Please see the second line item I have done.  I have already tired this and it does not work.

    Thanks and regards


    Venkatesh. S|MCTS(WCF, ADO.NET 3.5)|eMail: heman_1978@hotmail.com

    Monday, June 03, 2013 1:46 AM
  • Hi Venkatesh,

    Please make sure the "MalolanPC\Malolan" account has been added to the Administrators group already, and check the issue again.

    Regards,
    Mike Yin

    If you have any feedback on our support, please click here


    Mike Yin
    TechNet Community Support

    Tuesday, June 04, 2013 9:43 AM
  • Hi,

    This account is the administrator. I have mentioned that in my question itself


    Venkatesh. S|MCTS(WCF, ADO.NET 3.5)|eMail: heman_1978@hotmail.com

    Wednesday, June 05, 2013 1:28 AM
  • Hi Venkatesh,

    Thanks for your posting.

    Could you see the top right ribbon on the report manger page? I suggest that you log onto the operating system using the built-in Administrator account, and then assign both System-level and Item-level roles to the “MalolanPC\Malolan” account referring to the following document:

    Regards,
    Mike Yin

    If you have any feedback on our support, please click here


    Mike Yin
    TechNet Community Support

    Wednesday, June 05, 2013 1:41 AM
  • Hi Mike,

    Nothing seems to work for me. I keep getting this error inspite of logging in as  local  administrator and also launching the browser as local admin and trying the report server. I'm using Windows 8 with SQ server 2012 Developer edition. Browser is IE10. Any insights please. I'm totally frustrated here as nothing seems to working.


    Venkatesh. S|MCTS(WCF, ADO.NET 3.5)|eMail: heman_1978@hotmail.com

    Friday, June 14, 2013 12:32 AM
  • Hi Venkatesh,

    Thanks for your posting.

    Please try to close the UAC feature completely, restart the computer, and check the issue again.

    Regards,
    Mike Yin

    If you have any feedback on our support, please click here


    Mike Yin
    TechNet Community Support

    Wednesday, June 19, 2013 9:38 AM
  • What happens when you try to access RM from RS Configuration Manager?

    As Malolan can you login and access the database in SSMS?


    mysorian

    Wednesday, June 26, 2013 3:46 AM
  • Hi Mysorian,

    I'm unable to understand what you are saying please detail out the steps that I need to do?


    Venkatesh. S|MCTS(WCF, ADO.NET 3.5)|eMail: heman_1978@hotmail.com

    Thursday, June 27, 2013 12:43 AM
  • What happens when you try to access Report Manager from Reporting Services  Configuration Manager?

    Can you login as user 'MalolanPC\Malolan and access the Report Server database in SSMS?


    mysorian

    Thursday, June 27, 2013 1:10 AM
  • Hi Mysorian,

    I'm able to se access the SQL server ReportServer Database using the Malolanpc\malolan. No hassles in that. When I try to login using the  Report server URL from report server configuration, I get the same error stated above


    Venkatesh. S|MCTS(WCF, ADO.NET 3.5)|eMail: heman_1978@hotmail.com

    Friday, June 28, 2013 1:55 AM
  • Could you check these in your rsreportserver configuration file?

    <URLReservations>
    <Application>
    <Name>ReportServerWebService</Name>
    <VirtualDirectory>ReportServer_KAILUA</VirtualDirectory>
    <URLs>
    <URL>
    <UrlString>http://+:80</UrlString>
    <AccountSid>S-1-5-21-1263944626-711814217-1097418892-1000</AccountSid>
    <AccountName>HODENTEKWIN7\mysorian</AccountName>
    </URL>
    </URLs>
    </Application>
    <Application>
    <Name>ReportManager</Name>
    <VirtualDirectory>Reports_KAILUA</VirtualDirectory>
    <URLs>
    <URL>
    <UrlString>http://+:80</UrlString>
    <AccountSid>S-1-5-21-1263944626-711814217-1097418892-1000</AccountSid>
    <AccountName>HODENTEKWIN7\mysorian</AccountName>
    </URL>
    </URLs>
    </Application>
    </URLReservations>


    <IsReportManagerEnabled>True</IsReportManagerEnabled>


    Check if your AccountName is correctly configured in the above xml.


    mysorian

    Friday, June 28, 2013 2:58 AM
  • Hi Mysorian,

    My rsReportconfig URLS section looks like this

    <URLReservations>
      <Application>
       <Name>ReportServerWebService</Name>
       <VirtualDirectory>ReportServer_MALOLAN</VirtualDirectory>
       <URLs>
        <URL>
         <UrlString>http://+:80</UrlString>
         <AccountSid>S-1-5-80-2692091430-129943383-2393164537-2919257044-1302453727</AccountSid>
         <AccountName>NT Service\ReportServer$MALOLAN</AccountName>
        </URL>
       </URLs>
      </Application>
      <Application>
       <Name>ReportManager</Name>
       <VirtualDirectory>Reports</VirtualDirectory>
       <URLs>
        <URL>
         <UrlString>http://+:80</UrlString>
         <AccountSid>S-1-5-80-2692091430-129943383-2393164537-2919257044-1302453727</AccountSid>
         <AccountName>NT Service\ReportServer$MALOLAN</AccountName>
        </URL>
       </URLs>
      </Application>
     </URLReservations>

    As you said it does not have the administrator ID configured. Can you please tell me how to add the administrator id to it.


    Venkatesh. S|MCTS(WCF, ADO.NET 3.5)|eMail: heman_1978@hotmail.com

    Monday, July 01, 2013 1:12 AM
  • You can go to Control Panel and access services. In the Services window you can right click to see SQL Server Reporting  Services and in the logon you may be able to do it. Here you can make changes.


    mysorian

    Monday, July 01, 2013 4:17 AM
  • Hi Mysorian,

    I' not willing to change the SSRS to admin privileges. In fact I do not prefer to run any services with Admin privileges. I'm only looking for a method where by I will be work with the admin account. Is there a way to achieve this. I have done this in Windows 7 but after migrating to Window 8 I get this problem. In windows 7 , I would first launch the browser in admin privileges and in the home page I would go and add this add to SSRS. In Win 8 even while launching browser  in Admin account is not working and that is the issue


    Venkatesh. S|MCTS(WCF, ADO.NET 3.5)|eMail: heman_1978@hotmail.com

    Tuesday, July 02, 2013 2:01 AM
  • Sorry, I have not tried SSRS on Windows 8 platform

    mysorian

    Tuesday, July 02, 2013 7:18 PM