May 24, 2012 at 7:25 am
Hi, I recently took over a Reporting Services server and had to delete the encryption key to restart the server instance. The reports on the server runs off of a series of shared data sources. There's a "Data Sources" folder on the server. Since the encryption key was reset, the connection strings for the sources need to be reset. The previous person in charge of the Reporting Services server is no longer with the company. Does anybody know where the data sources .sln files (Business Intelligence Development Studio files) are stored?
May 24, 2012 at 7:33 am
They are stored on the machine used to develop the solution. If you have something like TFS or a source control environment, you could see if the person uploaded the solution to there to get a copy of the solution back, if not good hunting.
What I would say is get a copy of RSScriptor, and run it against your SSRS server, (unsure if it works with missing encryption keys) and then you can upload all the objects into a new solution and store it in a secure location incase this happens again. Then deploy the solution.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply