Email Subscription

Hi

I have uploaded a report onto my 2005 Reporting Manager and want to create a daily email of the report... How do I set up the email facility? Can someone give me a link?

I not sure what to do because the company uses Exchange Server and not SMTP....

Thanks

Hi,

First you need to set up the email settings for SSRS. If you use exchange server, that is fine, so you can add as your SMTP server.

Open Reporting Services Configuration manager from start menu/Microsoft SQL server 2005/Configuration tools.

Connect to your SSRS instance.

Choose email settings from the left sidebar of the application.

Specify the "Sender Address" as eg: noreply@.mydomain.tld

SMTP server name should be your exchange server.

If your exchange server is not letting anonymous sending, then assign the appropiate permission to the SSRS service account to send email through your exchange server.

Regards,

Janos

|||

thanks for the quick reply... I have alreasy tried what u sed but got the following error ;(

Failure sending mail: The transport failed to connect to the server.

does it matter that the mail server n reporting services server are 2 different machines?

thanks again

|||

Hi,

Try to ask your sys admin to add the appropiate permission to your SSRS service account on the exchange server.

I got also 2 separate server for SSRS and Exchange

Regards,

Janos

|||how do I set the permission to th SSRS account...soz Im new at networking and support stuff! ;'(|||

You can assign the permission on the SMTP virtual server in the Exchange management console,

maybe you should set up anonymous submit via teh smtp, then you do not need to specify explicit permission.