<div>
<div class="content wysiwyg-content">
I switch over from my primary node to the secondary node to syncronize them and now no one cannot use the reporting servicies after the switch over to the &nbsp;secondary machine. I check my services and my SQL Server Reporting services is started. I check the reporting services logfile and I found this message &quot;The encrypted value for the Dsn &nbsp;configuration setting cannot be decrypted :Microsoft.ReportingServic<wbr />es.Diagnos<wbr />tics.Utili<wbr />ties.Faile<wbr />dToDecrypt<wbr />ConfigInfo<wbr />rmationExc<wbr />eption: &nbsp;Info: &quot;&nbsp;I log on to the primary machine and check the rsreportserver.config against the secondary rsreportserver.config and the keys seems to be exactly the same. dos anyone knows the solution to fix this problem since I cannot switch back to my primary machine until tomorrow and I have customer over my back to use the reporting services.
</div>
</div>


I switch over from my primary node to the secondary node to syncronize them and now no one cannot use the reporting servicies after the switch over to the  secondary machine. I check my services and my SQL Server Reporting services is started. I check the reporting services logfile and I found this message "The encrypted value for the Dsn  configuration setting cannot be decrypted :Microsoft.ReportingServices.Diagnostics.Utilities.FailedToDecryptConfigInformationException:  Info: " I log on to the primary machine and check the rsreportserver.config against the secondary rsreportserver.config and the keys seems to be exactly the same. dos anyone knows the solution to fix this problem since I cannot switch back to my primary machine until tomorrow and I have customer over my back to use the reporting services.

MSSQLServer 2005 reporting services

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.