Hello all,
Since I installed SQL Server 2005 on the same server than SQL 2000, my Reporting Service is getting me this error:
"The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service. Check the documentation for more information. (rsReportServerDisabled) Get Online Help
Bad Data. (Exception from HRESULT: 0x80090005)"
I looked over some other logs and forums, and pretty much all pointed to use the rsactivate utility. Well, I am getting frustrated trying to run the rsactivate utility since I typed in the command rsactivate -r and got an error message that didn't expect to get.
Ej:
C:\>rsactivate -r
Either the WMI provider or the path to the local config file must be specified
Then I typed in the path and still got this:
C:\>rsactivate -r "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config"
Either the WMI provider or the path to the local config file must be specified
Does someone out there have had this situation or escenario before and what you did to solve it?....
I really need an input or hint on this, so I will appreciate any help.
Thanks in advance.
AJ
Hi I think your using the wrong command... To reactivate you must use the -c option, try this command reactivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config"
No comments:
Post a Comment