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
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 5:21 AM
Points: 296, Visits: 1,058
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
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 10:27 AM
Points: 586, Visits: 2,099
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