Solved

2005 Reporting Services Manual RDL Deployment

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

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…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

895 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

14 Experts available now in Live!

Get 1:1 Help Now