December 31, 2004 at 12:29 pm
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/co
July 1, 2005 at 7:29 am
Cool article - is it possible to implement a log shipping for the 2 Reporting Services databases, as a High Availablity story?
August 26, 2005 at 5:00 pm
Hello!
This is a great article. Thanks for the info. My question for you; WHen I develop my reports in Visual Studio and deploy them, they are then saved to the ReportServer database. Say I somehow lose my folder that contains all the VS projects for my reports and I need to recover my reports. Is there a way to extract them out of the database? I don't know if I am phrasing this right so please ask questions. I understand we can backup our file, I'm just wondering if there is away to extract the report definitions out of the database and back into Visual Studio. Thanks!!
September 16, 2005 at 10:13 am
This article is a life saver, helped us when our App server went down. Hats off to the author.
Thanks!
October 5, 2005 at 11:55 am
How did you loose your App server?
I'm following the article for a server where a vendor removed IIS from the system... now I'm left scrambling... I did however notice that the system was still sending out scheduled reports 😐
-- Francisco
October 5, 2005 at 1:22 pm
After uninstalling the RS, and then re-installing, I am now getting this error after I try to restore my key...
This edition of Reporting Services does not support web farm deployment. (rsInvalidRSEditionConfiguration)
I didn't do anything diffrent... how did I miss this very important step?
-- Francisco
February 22, 2006 at 10:29 am
had the same problem, but fixed it by deleting the rows from the keys table that referred to the old <InstallationID> using rskeymgmt -r <InstallationId>
February 16, 2007 at 7:40 am
Very useful article. But the first defense is alway an image made by Ghost or Acronis etc.
February 16, 2007 at 9:14 am
I think another mentioned this. If you move the databases to a new server (not part of this problem) and you move the reporting services to a new server and you are not using the enterprise edition then you have to go into the keys database and remove one of the keys after you reactivate the system. In slq 2005 you can reactivate the system by adding the password, again, to the authentication in the reporting services config tool. I have to duplicate our production environment in QA and do this quite often. I also back up the RS database everynight, along with the system databases. You can mirror these databases or put them on your cluster if you have one. Log shipping would work but it is not like you should be changing your production reports every 5 minutes.
February 16, 2007 at 11:11 am
It is easy to get the report definition out. Just go to the Report Services web page and navigate to the report you need. Switch to the properties tab and choose "Edit". This will be an export of the rdl file.
There might be a way to get the definition from the database, haven't tried that.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
February 22, 2007 at 3:35 pm
This is a great article! However, I could not make it work for when I have subscriptions for the reports. I am unable to edit the subscriptions after the restore on a different machine. Any ideas?
November 11, 2010 at 9:55 pm
I'm wondering how to backup the SSRS encryption keys from a remote server. As far as I know, rskeymgmt only works on the RS server itself.
RSConfigTool.exe can connect remotely, but its a GUI based tool and doesnt work on command line.
My company has quite a number of RS servers and its not easy to go into each RS server to backup the encryption keys. Is there anyway to automate the backup from a central location, etc?
Simon
Simon Liew
Microsoft Certified Master: SQL Server 2008
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply