Moving/Deploying my Reporting Services Project to a remote server

Posted on 2009-04-24
Last Modified: 2012-05-06
I created a Reporting Services project on my local machine,
The data source, and database that the reports use/access are on
a remote SQL Server (Lets call it Server XYZ)

So here is my question. How shall I deploy these reports
to the SQL server Server machine "XYZ", from my local machine? Can I simply copy them to the
same directory structure on the remote server that hosts the Reporting
services projects? Because basically my local directory structure for the
reports mimics the location of those  Reporting Services projects on the server:

C:\Documents and Settings\AV_KP_Admin\My Documents\Visual Studio 2005\Projects\.....
Question by:brgdotnet
    LVL 26

    Accepted Solution

    You deploy reports to the reporting server, see for some how-to topics on Publishing reports
    LVL 2

    Author Comment

    Actually I just moved the Reporting service project from my local machine to the server. I placed it in the same directory structure. I then opened it up built and deployed it. It worked great. I did not read the article you posted though. I will read it later.
    LVL 2

    Author Closing Comment

    Average response.
    LVL 26

    Expert Comment

    by:Chris Luttrell
    Yes, you can copy it and build it again, we have done that in the past.  But what if you have a producion server that they refuse to allow the tools be loaded on for security reasons.  Or what if the directory structure is different.  Or if you have multiple servers to deploy to, do you want to have to copy to each and log on and build the reports again.  Using the deployment tools and configuration manager, we can build locally for development and then deploy to multiple servers for Production, QA, Training etc.  It is just good to learn what tools are available and how to use them, especially in stricter environments.  Not trying to be mean, just trying to explain why I steer folks away from the old "I'll just copy everything" approach.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Suggested Solutions

    Written by Valentino Vranken. Introduction: In a previous article ( I announced that I would writ…
    After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now