Post reply

Migrating SSRS reports from one server to another

  • January 21, 2014 at 11:06 am

    #396140

    Hi,

    I ma trying to migrate SSRS reports from one server to another using Report Sync. When I provide the sa login/pwd, I get the following error :

    Loading Failed. The request failed with HTTP status 401:Unauthorized.

    Please help !

    Any other tool that can help us migrate the reports . We have SSRS native mode.

    Thanks,

    PSB

  • January 22, 2014 at 9:30 am

    #1682483

    if you have a lot of reports to use you need the SSRS Scripter. I remember it being easy to use, but that was a year or two ago. I think you give it a source and destination, and then select the folders you want to move and it does it for you. fabulous tool. I hope I provided the right link

    I just took a look at the tool you were using and it looks almost identical to the one I used. if you have auth problems with one tool you may have the same problem with any tool you try.

    SSRS has it's own level of security on top of the db security. you may have to add sa to the ssrs administators. I'd try a different account. I'm not up on my best practices but I'm sure adding SA to SSRS administrators isn't one.

    you add this via the report manager, site settings, security.

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

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