Encryption Key
in [Reports]
|
From: RouteC on 5 Feb 2007 10:19 I am getting the following error while configuring the reporting services on my local machine. I cannot restore the key as I do not know the file or the password. Somebody please help! ReportServicesConfigUI.WMIProvider.WMIProviderException: The encrypted value for the "LogonCred" configuration setting cannot be decrypted. (rsFailedToDecryptConfigInformation) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.DeleteEncryptedInformation()
From: Radoslaw Lebkowski on 5 Feb 2007 11:02 Hello, Are you installing a new version of Reporting Services (with clear ReportServer database) or just reinstalling it with using previous version of ReportServer database?? It looks like that you've reinstalled Reporting Services without recovering previous encryption key. If you don't have any copy of your previous encryption key, the only way to make Reporting Services content available is to delete all unusable encrypted data from ReportServer database. Follow these steps to apply the encryption key to the report server database: 1.. Run rskeymgmt.exe locally on the computer that hosts the report server. You must use the -d apply argument. The following example illustrates the argument you must specify: rskeymgmt -d 2.. Restart Internet Information Service (IIS). After the values are removed, you must re-specify the values as follows: 1.. Run rsconfig utility to specify a report server connection. This step replaces the report server connection information. For more information, see Configuring a Report Server Connection and rsconfig Utility. 2.. If you are supporting unattended report execution for reports that do not use credentials, run rsconfig to specify the account used for this purpose. For more information, see Configuring an Account for Unattended Report Processing. 3.. For each report and shared data source that uses stored credentials, you must retype the user name and password. For more information, see Specifying Credential and Connection Information. 4.. Open and resave each subscription. Subscriptions retain residual information about the encrypted credentials deleted during the rskeymgmt delete operation. You can update the subscription by opening and saving it. You do not need to modify or recreate it. I hope this infomation will helpful. Best Regards, Radoslaw Lebkowski U�ytkownik "RouteC" <RouteC(a)discussions.microsoft.com> napisa� w wiadomo�ci news:D246447F-1622-4230-AC73-71D0F1073C11(a)microsoft.com... >I am getting the following error while configuring the reporting services >on > my local machine. I cannot restore the key as I do not know the file or > the > password. > Somebody please help! > > ReportServicesConfigUI.WMIProvider.WMIProviderException: The encrypted > value > for the "LogonCred" configuration setting cannot be decrypted. > (rsFailedToDecryptConfigInformation) > at > ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject > mo) > at > ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.DeleteEncryptedInformation()
From: RouteC on 5 Feb 2007 11:56 Hi Rad, The very first step in trying to delete the key is giving me the same exception which is ReportServicesConfigUI.WMIProvider.WMIProviderException: The encrypted value for the "LogonCred" configuration setting cannot be decrypted. rskeymgmt -d -i instance This is completely new installation in 2steps. 1. Installed sql server 2005 with all other services except reporting services as iis was not installed at that time. 2. Installed reporting services. "Radoslaw Lebkowski" wrote: > Hello, > > Are you installing a new version of Reporting Services (with clear > ReportServer database) or just reinstalling it with using previous version > of ReportServer database?? > It looks like that you've reinstalled Reporting Services without recovering > previous encryption key. > If you don't have any copy of your previous encryption key, the only way to > make Reporting Services content available is to delete all unusable > encrypted data from ReportServer database. > Follow these steps to apply the encryption key to the report server > database: > > 1.. Run rskeymgmt.exe locally on the computer that hosts the report > server. You must use the -d apply argument. The following example > illustrates the argument you must specify: > rskeymgmt -d > 2.. Restart Internet Information Service (IIS). > After the values are removed, you must re-specify the values as follows: > > 1.. Run rsconfig utility to specify a report server connection. This step > replaces the report server connection information. For more information, see > Configuring a Report Server Connection and rsconfig Utility. > 2.. If you are supporting unattended report execution for reports that do > not use credentials, run rsconfig to specify the account used for this > purpose. For more information, see Configuring an Account for Unattended > Report Processing. > 3.. For each report and shared data source that uses stored credentials, > you must retype the user name and password. For more information, see > Specifying Credential and Connection Information. > 4.. Open and resave each subscription. Subscriptions retain residual > information about the encrypted credentials deleted during the rskeymgmt > delete operation. You can update the subscription by opening and saving it. > You do not need to modify or recreate it. > I hope this infomation will helpful. > > Best Regards, > Radoslaw Lebkowski > > > > U¿ytkownik "RouteC" <RouteC(a)discussions.microsoft.com> napisa³ w wiadomo¶ci > news:D246447F-1622-4230-AC73-71D0F1073C11(a)microsoft.com... > >I am getting the following error while configuring the reporting services > >on > > my local machine. I cannot restore the key as I do not know the file or > > the > > password. > > Somebody please help! > > > > ReportServicesConfigUI.WMIProvider.WMIProviderException: The encrypted > > value > > for the "LogonCred" configuration setting cannot be decrypted. > > (rsFailedToDecryptConfigInformation) > > at > > ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject > > mo) > > at > > ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.DeleteEncryptedInformation() > > >
From: Radoslaw Lebkowski on 5 Feb 2007 13:11 Hmm, that's a little strange situation. Under the following link there is a very similar problem with LogonCred decryption problem. http://groups.google.pl/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/ec7858be1ef25e24/9f72570a671b74e7?lnk=st&q=LogonCred+decrypted&rnum=1&hl=pl#9f72570a671b74e7 Maybe you have problem with authorization a connection to ReportServer database (bad values contained in RSReportServer.config file used to connect to the report server database) Try to use rsconfig utility described below http://msdn2.microsoft.com/en-us/library/aa179654(SQL.80).aspx Regards Radoslaw Lebkowski U�ytkownik "RouteC" <RouteC(a)discussions.microsoft.com> napisa� w wiadomo�ci news:7BC3B705-71DF-4B48-93FE-6959E94A51FF(a)microsoft.com... > Hi Rad, > > The very first step in trying to delete the key is giving me the same > exception which is > ReportServicesConfigUI.WMIProvider.WMIProviderException: > The encrypted value > for the "LogonCred" configuration setting cannot be decrypted. > > rskeymgmt -d -i instance > > This is completely new installation in 2steps. > > 1. Installed sql server 2005 with all other services except reporting > services as iis was not installed at that time. > > 2. Installed reporting services. > > "Radoslaw Lebkowski" wrote: > >> Hello, >> >> Are you installing a new version of Reporting Services (with clear >> ReportServer database) or just reinstalling it with using previous >> version >> of ReportServer database?? >> It looks like that you've reinstalled Reporting Services without >> recovering >> previous encryption key. >> If you don't have any copy of your previous encryption key, the only way >> to >> make Reporting Services content available is to delete all unusable >> encrypted data from ReportServer database. >> Follow these steps to apply the encryption key to the report server >> database: >> >> 1.. Run rskeymgmt.exe locally on the computer that hosts the report >> server. You must use the -d apply argument. The following example >> illustrates the argument you must specify: >> rskeymgmt -d >> 2.. Restart Internet Information Service (IIS). >> After the values are removed, you must re-specify the values as follows: >> >> 1.. Run rsconfig utility to specify a report server connection. This >> step >> replaces the report server connection information. For more information, >> see >> Configuring a Report Server Connection and rsconfig Utility. >> 2.. If you are supporting unattended report execution for reports that >> do >> not use credentials, run rsconfig to specify the account used for this >> purpose. For more information, see Configuring an Account for Unattended >> Report Processing. >> 3.. For each report and shared data source that uses stored >> credentials, >> you must retype the user name and password. For more information, see >> Specifying Credential and Connection Information. >> 4.. Open and resave each subscription. Subscriptions retain residual >> information about the encrypted credentials deleted during the rskeymgmt >> delete operation. You can update the subscription by opening and saving >> it. >> You do not need to modify or recreate it. >> I hope this infomation will helpful. >> >> Best Regards, >> Radoslaw Lebkowski >> >> >> >> U?ytkownik "RouteC" <RouteC(a)discussions.microsoft.com> napisa3 w >> wiadomo?ci >> news:D246447F-1622-4230-AC73-71D0F1073C11(a)microsoft.com... >> >I am getting the following error while configuring the reporting >> >services >> >on >> > my local machine. I cannot restore the key as I do not know the file >> > or >> > the >> > password. >> > Somebody please help! >> > >> > ReportServicesConfigUI.WMIProvider.WMIProviderException: The encrypted >> > value >> > for the "LogonCred" configuration setting cannot be decrypted. >> > (rsFailedToDecryptConfigInformation) >> > at >> > ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject >> > mo) >> > at >> > ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.DeleteEncryptedInformation() >> >> >>
|
Pages: 1 Prev: Intermittent rsInternalError errors - exception in UpdateTimingInf Next: rsInternalError |