SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Migrating SSRS reports from one server to another


Migrating SSRS reports from one server to another

Author
Message
PSB
PSB
SSC Eights!
SSC Eights! (967 reputation)SSC Eights! (967 reputation)SSC Eights! (967 reputation)SSC Eights! (967 reputation)SSC Eights! (967 reputation)SSC Eights! (967 reputation)SSC Eights! (967 reputation)SSC Eights! (967 reputation)

Group: General Forum Members
Points: 967 Visits: 1536
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
Steven.Howes
Steven.Howes
SSC Eights!
SSC Eights! (868 reputation)SSC Eights! (868 reputation)SSC Eights! (868 reputation)SSC Eights! (868 reputation)SSC Eights! (868 reputation)SSC Eights! (868 reputation)SSC Eights! (868 reputation)SSC Eights! (868 reputation)

Group: General Forum Members
Points: 868 Visits: 2340
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search