Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Migrating SSRS reports from one server to another Expand / Collapse
Author
Message
Posted Tuesday, January 21, 2014 11:06 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, September 30, 2014 5:22 AM
Points: 300, Visits: 1,070
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
Post #1533280
Posted Wednesday, January 22, 2014 9:30 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, December 19, 2014 9:37 AM
Points: 612, Visits: 2,146
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.

Post #1533723
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse