• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 332
  • Last Modified:

Moving/Deploying my Reporting Services Project to a remote server

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\.....
0
brgdotnet
Asked:
brgdotnet
  • 2
  • 2
1 Solution
 
Chris LuttrellSenior Database ArchitectCommented:
You deploy reports to the reporting server, see http://msdn.microsoft.com/en-us/library/ms345236.aspx for some how-to topics on Publishing reports
0
 
brgdotnetcontractorAuthor Commented:
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.
0
 
brgdotnetcontractorAuthor Commented:
Average response.
0
 
Chris LuttrellSenior Database ArchitectCommented:
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.
0
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.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now