Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Move the SQL Report server to another server

Posted on 2014-09-16
7
Medium Priority
?
174 Views
Last Modified: 2014-09-19
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
0
Comment
Question by:AXISHK
  • 4
  • 3
7 Comments
 
LVL 15

Expert Comment

by:Vikas Garg
ID: 40327427
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 ...
0
 

Author Comment

by:AXISHK
ID: 40327473
Does it mean the SQL reports are stored in a database rather than a folder on a hard disk ? Tks
0
 
LVL 15

Expert Comment

by:Vikas Garg
ID: 40327576
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
0
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 

Author Comment

by:AXISHK
ID: 40327591
How can I check the location of .rdl file ? Tks
0
 
LVL 15

Expert Comment

by:Vikas Garg
ID: 40327599
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
0
 

Author Comment

by:AXISHK
ID: 40329552
Sorry, can you assist me with screen dump where can I download the .rdl report ? Tks
BI-Report.png
0
 
LVL 15

Accepted Solution

by:
Vikas Garg earned 2000 total points
ID: 40329599
You have to use Report manager

It is report server
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question