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 advanceAny errors or information from the logs of SQL server, IIS & Event viewer? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
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?
]]>