Solved

2005 Reporting Services Manual RDL Deployment

Posted on 2008-06-12
5
1,546 Views
Last Modified: 2012-05-05
I have inherited a deployment running inside a custom .net application. I'm looking to deploy an updated version of a report to the report server. My question is there a manual way of deploying an RDL? I'm afraid of taking down the application entirely and I do not have detailed enough documentation to bring it back up. Thanks!
0
Comment
Question by:BillSinc
  • 2
  • 2
5 Comments
 
LVL 29

Expert Comment

by:QPR
ID: 21775072
Is the RDL stored in the filesystem?
Does the new use the same datasource/connection as the original?
Can you not just overwrite the new rdl over the old?

With a report hosted with report server you can just right click the report.rdl Visual Studio and deploy it. It will overwrite the existing one on the server.
Never had to deply one to an app tho.
0
 

Author Comment

by:BillSinc
ID: 21779296
This is a production server. I cannot find any RDLs on the file system and therefore cannot just overwrite one.  I do have the new RDL, which does use the same conection.  I know how to deploy from VS but being that I cannot yet mirror the production system and need to get this report updated before I've fully setup a test environment I was looking for an alternative.  
0
 
LVL 2

Expert Comment

by:vasureddym
ID: 21783372
Are you considering login on to ReportServer & publishing the report there as manual against publishing report from .Net application.
0
 
LVL 29

Expert Comment

by:QPR
ID: 21783689
this application you mention.... does it have the reports embeddded in it or does it simply link to the report server?
If it just links then do as BillSinc mentions.
Go to the report server.
Navigate to the folder where the report will live.
Go to properties and upload the new report (RDL).
This will overwrite the current one.
0
 

Accepted Solution

by:
BillSinc earned 0 total points
ID: 21796089
I was finally able to login to the report server using SQL Management Studio and Forms authentication, which mimics how the users interact to the report server.  I had to add my user name to the config file in the admin section inside the reportserver directory to give me full access. Inside the management studio I can view the reports tree and import, export, overwrite, etc.  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

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

830 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