Key Not Valid For Use in Specified State
7/18/2006 11:23:59 AM
Key not valid for use in specified state.
Have you seen this error? I was in the middle of working on a SQL Reporting Service and was notified by Windows Update that there were some "critical updates" that needed to be applied. This was last week (~7/13/06 ). The operating system happens to be Windows Server 2003 SP1. After installing the updates I was prompted to to restart my computer (which I did) and was mortified when my SQL Reporting Services stopped working, all of them!
The steps below were taken by me to get my machine up and running again. SQL Reporting Services works beautifully now.
- Uninstall the recent Windows Updates
- <DRIVE>:\Documents and Settings\<machine_name>\ASPNET\Application Data\Microsoft\Crypto\RSA\
- Search for '1aedd7b5699f3d6a88e354100b596aae*'
- Delete this file
- Open command prompt
- rsactivate -r -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config"
- Restart ReportServer
- Continue working on SQL Reports
Related:
Roman Rehak: Weekly SQL Server Tips
How to Activate SQL Server 2000 Reporting Service
Kate Gregory: Accidentally Killed my Reporting Services Installation
JavaScript,
SQL
