Solved

2005 Reporting Services Manual RDL Deployment

Posted on 2008-06-12
5
1,538 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video discusses moving either the default database or any database to a new volume.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) 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…

762 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

11 Experts available now in Live!

Get 1:1 Help Now