Solved

BIDS 2012 - How to deploy SSRS data sources to different servers (dev & prod)

Posted on 2014-03-22
2
810 Views
Last Modified: 2014-03-25
Our development SQL Server is on a different physical server than our test and production servers.  How can I set SSRS up such that we can quickly deploy to the desired server and the data sources are configured correctly for the destination?

We are using BIDS Visual Studio 2012 connecting to a SQL Server 2012 server.
0
Comment
Question by:canuckconsulting
2 Comments
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 500 total points
ID: 39950544
Can you just deploy the report configured to use an external data source, but without also deploying the data source? If you put data sources in the same location on both the UAT and production servers, called the same thing, but pointing to the proper destinations (UAT and production, respectively), the deployed reports should point to the correct location.
0
 

Author Closing Comment

by:canuckconsulting
ID: 39955074
Thanks!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

792 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