Post reply

Moving reports from one 'my reports' folder to another.

  • February 22, 2010 at 3:26 am

    #211538

    I am a DBA and one of my users has recently married which has resulted in a name change for her and a subsequent user id change in AD.

    She can no longer see her reports as they are linked to her old user id.

    I connected to the reporting services server and connected via the URL, the was a list of user folders where there were folders for both her new and old ids.

    I selected all the reports and directories and clicked the move button, selected the new directory and ok which then resulted in an 'insufficient permissions' error. I am a domain admin as well as a DBA and had connected using my admin account.

    Any ideas on how this can be resolved.

    Thanks

    Paul

  • February 22, 2010 at 3:38 am

    #1122809

    Are the user folders created under the "NT AUTHORITY\SYSTEM" account?

    Only way I have been about to get these is to extract the report using SSRS Scripter..

    http://www.sqldbatips.com/showarticle.asp?ID=62

  • February 22, 2010 at 4:22 am

    #1122831

    All the folders under users were create by NT AUTHORITY\SYSTEM.

    I tried RSScripterfirst but I have just tried again with the current build and get the following error

    The permissions granted to user 'me' are insufficient for performing this operation.

    Thanks

    Paul

  • February 22, 2010 at 4:28 am

    #1122834

    If you use the web interface to assign "you" permissions then it shou,ld give you access.

    You will need to add your user name to \Users Folders\Username\My Reports.

    Just tested myself and all seems to work ok.

    SSRS is using the "ReportServer" app pool details when creating the folders...

  • February 22, 2010 at 4:57 am

    #1122847

    Many thanks for this.

    I had added myself to everything at the users folders level and assumed that the parenting security would filter down, it does but only to the actual user directory and not to the 'my reports' directory underneath. I checked one but not the other!

    Just waiting for confirmation from the user that they can see their reports.

    Thanks again.

    Paul

Viewing 5 posts - 1 through 4 (of 4 total)

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