Showing posts with label sending. Show all posts
Showing posts with label sending. Show all posts

Monday, March 26, 2012

Encryption Key Errors

I got error as below:

Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.

Then i found error in log file as below:

ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information., AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service account doesn't have rights to check domain user SIDs.;
Info:

Does that mean sth to do with SQL agent running account or SQl Server Report Service running account ?

Thanks

Nick

http://support.microsoft.com/?kbid=842423|||

Thanks for you information. Teo

when i change the Local account for running SQL Server Report Services to dominon account, then i got http://servername/reports to view report, then i got error below:

An error has occurred during report processing. (rsProcessingAborted)
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. Check the documentation for more information. (rsReportServerDisabled) (rsRPCError)
Bad Data. (Exception from HRESULT: 0x80090005)

What i am understand is that when i create this report it's under local system account , so this report doesn't work when i change the user account. is that right? and how can i handle it ?

Cheers

Nick

|||You will need to re-initialize the server. Assuming RS 2005, use the Reporting Services Configuration (found under the Configuration Tools program group in Microsoft SQL Server 2005 group) to do so. Or, you can drop the decrypted content by running rskeymgmt -d (you will need to reset your data source connection strings after this).|||

when you say re-initialize the server , does that mean i need to delete the existing isntance from reporting service configruation , and create a new one. not just click the initialize button .

is that right understanding?

Cheers

Nick

|||By just clicking on the Initialization button in the Reporting Services Configuration tool.|||

i got erroer when i click initialize button in Report service configuration tool,

"Joining report server ac553f4....... to the web farm of the local instance" The task failed.

Exception Details"

ReportServicesConfigUI.WMIProvider.WMIProviderException: 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. Check the documentation for more information. (rsReportServerDisabled)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.InitializeReportServer(String installationId)

Thanks

Nick

|||it looks like the only option is to drop the encryption content using rskeymgmt -d. You will need to reset your data source credentials after this.|||

Hi all, I have seen that I have a similar problem with Encryption Key working with reports. My problem is that I′m working with VSt2003 and I have some reports made, but yesterday I was just testing some ASP.NET examples with VS2005. This morning when I continued working with reports in VS2003, I recieved this error:

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. Check the documentation for more information. (rsReportServerDisabled)

And it wasn′t possible to see the reports.

Do you now the way to fix this problem?

Thanks in Advance

|||I don't know what happened yesterday but somehow you managed to deactivate the server. Re-initializing ASP.NET (aspnet_regiis) will do the trick. Anyway, if you have backed up the encryption key (you did, didn't you?), now is the perfect time to use the Reporting Services Configuration utility and restore it. If you haven't, do rskeymgmt -d.sql

Friday, March 9, 2012

Encrypt and Decrypt Data - Subscription

Hi All,
I am subsrcibing a report through the Report Manager, before sending the
mail, i need to encrypt the data in the report and send it to the user.
I can do the encryption but passing the data to a function in a custom
assembly and then return the encrypted data to the report and then send a
mail.
But at the receiver end, the report data should be decrypted and display in
the mail when the user open the subscribed mail.
Any inputs..
Thanks
Balaji
--
Message posted via http://www.sqlmonster.comIn this scenario your clients would have to have your decrypt utility. And
that would only work if your export format is one of the text based ones
(csv, xml, etc) and not one of the image based ones (tiff, pdf, etc).
What I did was, based on my application logic, create subscriptions, have
reports saved to a file share, have a windows service process take the
report and save it in an image field in the database. To get the report the
user logs into my web app (which is https and secure) and retrieves the
report.
--
Adrian M.
MCP
"BALAJI via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in message
news:bd5744926a0e4a00b632863dfb28dc20@.SQLMonster.com...
> Hi All,
> I am subsrcibing a report through the Report Manager, before sending the
> mail, i need to encrypt the data in the report and send it to the user.
> I can do the encryption but passing the data to a function in a custom
> assembly and then return the encrypted data to the report and then send a
> mail.
> But at the receiver end, the report data should be decrypted and display
> in
> the mail when the user open the subscribed mail.
> Any inputs..
> Thanks
> Balaji
> --
> Message posted via http://www.sqlmonster.com