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
AXISHKAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vikas GargBusiness Intelligence DeveloperCommented:
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
AXISHKAuthor Commented:
Does it mean the SQL reports are stored in a database rather than a folder on a hard disk ? Tks
0
Vikas GargBusiness Intelligence DeveloperCommented:
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
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

AXISHKAuthor Commented:
How can I check the location of .rdl file ? Tks
0
Vikas GargBusiness Intelligence DeveloperCommented:
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
AXISHKAuthor Commented:
Sorry, can you assist me with screen dump where can I download the .rdl report ? Tks
BI-Report.png
0
Vikas GargBusiness Intelligence DeveloperCommented:
You have to use Report manager

It is report server
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.