Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 encryption

Author  Topic 

Richard101
Starting Member

30 Posts

Posted - 2007-12-05 : 06:40:05
Hi All

quick question

We've a customer who's lost their reporting-services encryption-key password.

any hope ??

richard101

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-05 : 06:59:39
Huh?

How is encryption key related to reporting?



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

Richard101
Starting Member

30 Posts

Posted - 2007-12-05 : 07:22:12
I beleive an encryption-key is generated during activation.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-05 : 07:23:46
Activation of what?



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

Richard101
Starting Member

30 Posts

Posted - 2007-12-05 : 07:37:32
Reporting Services

http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsactiveproc.mspx

Forgive me, but I'm begining to suspect you may not be the RS expert I was hoping for :-)
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-05 : 07:45:39
I am a but stunned, but I have never encountered this failure with RS.
That's why I asked for more information for some clue to why this has occured.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

Richard101
Starting Member

30 Posts

Posted - 2007-12-05 : 09:24:55
apparently a third party installed biztalk that (somehow) corrupted the synchronus(?) encryption-key (atleast they're getting the blame :-) ). ON-top-of-which my customer generated a new key(?), somehow. And now none of there reports work. From what I've read I can imagine two options a) reset the thing again, and setup the users/config details as they should be b) restore Mondays backup (pre biztalk).

Go to Top of Page

Richard101
Starting Member

30 Posts

Posted - 2007-12-09 : 02:26:09
Fixed, thanks for all your help, simply generated new password.
Go to Top of Page
   

- Advertisement -