Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

2005 Reporting Services Manual RDL Deployment

Posted on 2008-06-12
5
Medium Priority
?
1,550 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Integration Management Part 2
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…

971 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