Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

2005 Reporting Services Manual RDL Deployment

Posted on 2008-06-12
5
Medium Priority
?
1,549 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
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…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

670 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