asked on

Move the SQL Report server to another server

Need to move all the reports from server A (http://servera/reports) to server B (http://serverb/reports).

Where can I tell the physical location of these reports ? Are they saved in a physical folder or in a SQL database ?

Where can I grant a user right access to use the report in server A ?

Tks

Vikas Garg

Hi,

Please follow this link which will let you know the Step by Step process for transferring Reports from one server to another

http://www.mssqltips.com/sqlservertip/2692/migrating-sql-reporting-services-to-a-new-server-by-moving-the-reporting-services-databases/

Hope this would help you ...

AXISHK

ASKER

Does it mean the SQL reports are stored in a database rather than a folder on a hard disk ? Tks

Vikas Garg

This is migrating Reporting Server.

You have to move the reports manually to the folder.

You can also deploy reports to the new report manager by attaching the existing reports ...

Download the report as a .rdl file from one server, and upload the .rdl file to create the report on the new server

AXISHK

ASKER

How can I check the location of .rdl file ? Tks

Vikas Garg

No need to worry for that,

You can download .rdl files directly from report manager

Store to a local folder

Paste them to remote server folder

upload to that report manager from the folder using upload

AXISHK

ASKER

Sorry, can you assist me with screen dump where can I download the .rdl report ? Tks
BI-Report.png

ASKER CERTIFIED SOLUTION

Vikas Garg

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial