Deploy Error - URGENT PLEASE

Hi,
While deploying my report recently, I am getting following error. Previously
I was able to deploy sucessfully. I am seeing this error recently. Can anyone
help. Error says to look into documentation, but I could not get any clue.
"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."Check this
http://support.microsoft.com/default.aspx?kbid=842421
--
Gustavo Larriera, MVP
Uruguay LatAm
http://sqljunkies.com/weblog/gux/
--
Este mensaje se proporciona "COMO ESTA" sin garantias y no otorga ningun
derecho / This posting is provided "AS IS" with no warranties, and confers
no rights.
--
"bob" <bob@.discussions.microsoft.com> wrote in message
news:136BC228-C49E-4971-B773-7C0ED03BE2D6@.microsoft.com...
> Hi,
> While deploying my report recently, I am getting following error.
> Previously
> I was able to deploy sucessfully. I am seeing this error recently. Can
> anyone
> help. Error says to look into documentation, but I could not get any clue.
> "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."
>|||If you have a backup of the reportserver DBs just replace with the backup
ones. or else just do this:
go to commna prompt
go to C:\Program Files\Microsoft SQL Server\80\Tools\Binn
you should find rskeymgmt,rsconfig etc etc
from this location do this --> "rsKeyMgmt -d"
This deletes all the old symmetric keys
Then restart your IIS
then go back to the command prompt and do "rsconfig -e -u (domain\username)
-p (password)"
This will create the encrypted symmetric keys again.
The user name and password to use are the ones the report server is running
under. (maybe your windows account).
Hope this helps
"bob" wrote:
> Hi,
> While deploying my report recently, I am getting following error. Previously
> I was able to deploy sucessfully. I am seeing this error recently. Can anyone
> help. Error says to look into documentation, but I could not get any clue.
> "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."
>|||Hi Ni,
Thanks a ton, it worked for me.
:-))
Bob.
"NI" wrote:
> If you have a backup of the reportserver DBs just replace with the backup
> ones. or else just do this:
> go to commna prompt
> go to C:\Program Files\Microsoft SQL Server\80\Tools\Binn
> you should find rskeymgmt,rsconfig etc etc
> from this location do this --> "rsKeyMgmt -d"
> This deletes all the old symmetric keys
> Then restart your IIS
> then go back to the command prompt and do "rsconfig -e -u (domain\username)
> -p (password)"
> This will create the encrypted symmetric keys again.
> The user name and password to use are the ones the report server is running
> under. (maybe your windows account).
> Hope this helps
>
> "bob" wrote:
> > Hi,
> >
> > While deploying my report recently, I am getting following error. Previously
> > I was able to deploy sucessfully. I am seeing this error recently. Can anyone
> > help. Error says to look into documentation, but I could not get any clue.
> >
> > "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."
> >