sql server reporting services: RS deactivated after upgrade from Win 2000 to W2k3 -- sql server reporting services

You're in the

sql server reporting services

group:

RS deactivated after upgrade from Win 2000 to W2k3

Jéjé
3/8/2005 7:00:18 PM

sql server reporting services:

Hi,

After I have upgraded my server, RS stop working .
a.. 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
a.. Bad Data.
I have the Key (exported using the rskeymgmt utility)
But I can't reapply the key:
an "Unable to connect to the database" error appear when I try to reapply
the key.

I have lost a document on the Microsoft web site which explain the entire
process to reactivate RS.
Anyone has the link?
or can explain the procedure?

thanks

Jerome.

Re: RS deactivated after upgrade from Win 2000 to W2k3

Douglas McDowell
3/9/2005 12:04:49 AM

You may need to use rsconfig to reset that database connection if it is
having issues:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsuiref/htm/cpu_rsconfig_v1_5f1e.asp

Here is an activation doc for the rsactivate utility:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsuiref/htm/cpu_rsconfig_v1_6yqq.asp
--
Douglas McDowell douglas@nospam.solidqualitylearning.com

[quoted text, click to view]

RE: RS deactivated after upgrade from Win 2000 to W2k3

Jeffffffffff
3/9/2005 9:17:04 AM

I think this is the key management article you are referring to....

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_dbadmin_v1_98xh.asp?frame=true

[quoted text, click to view]

Re: RS deactivated after upgrade from Win 2000 to W2k3

Jéjé
3/9/2005 4:08:15 PM

its ok

I'have found (or re-found ) the solution.
I have replaced the oledb32.dll file on the server by the 2.8 version
(instead-of the 2.7 version which is not upgraded during the Win2003
upgrade)

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn