Emailing a Report | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Emailing a Report

Hi: Am trying to get a subscription report to run on a schedule and email me a test report. I schedule the job via report manager and I can see the job has run in in Enterprise Manager but no emailed report. My test box has SQL Server, report services, IIS, SMTP, and VisStudio loaded on it. I have tested SMTP via a stored proc so I know SMTP works. Any ideas? Thanks in advance

Any errors or information from the logs of SQL server, IIS & Event viewer? Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
One error I found in the applicaton log was
Failed to decrypt symmetric key. Most likely cause is the serivce username has changed. I not sure what service this is talking about. SQL Logs and SMTP logs show nothing unusual. Any thoughts?