SQL Server Performance

Emailing a Report

Discussion in 'SQL Server Reporting Services' started by mdemmitt, Apr 20, 2004.

  1. mdemmitt New Member

    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
    mdemmitt, Apr 20, 2004
    #2

  2. satya Moderator

    Any 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.
    satya, Apr 20, 2004
    #2

  3. mdemmitt New Member

    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?
    mdemmitt, Apr 23, 2004
    #2

Share This Page