September 14, 2022 at 4:24 pm
We are in the process of moving SSRS 2104 web servers in a scale out deployment from one domain to another.
The unfortunate thing is that the production environment is not even close to the lower environments, mainly because of some really bad practices that I inherited and subsequently stopped from happening. So, we were able to move the lower environments with no issues, but production had failed miserably this past weekend.
The issue was the encrypted content. I exported it from both servers, made the domain move, and got an error about restoring the encrypted content. One server restored fine, the other didn't.
I am trying to prepare for the worst case, which would be to delete the encrypted content and re-create it. Manually re-adding the user names and passwords for all of the shared data sources will be painful.
I want to export the data sources with the users and passwords so I can automate re-creating them. This article was promising, but it still does not do what I need. https://www.sqlservercentral.com/forums/topic/decipher-reportserver-datasource-connectionstring
Can anyone point me in the right direction? Ideas? Suggestions?
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
September 15, 2022 at 5:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply