Friday, January 26, 2007

SQL Server 2000 Reporting Services Email Subscriptions


Problem: Problem with Email Subscriptions. Error generated while trying to send emails

Solution: Edit the rsreportservice.config present in the following path of the report server.
$C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReport­Server.config

Inside the rsreportservice.config:
block has the necessary email related keys.Edit the following keys:

1. (Set the Default Email Server Name)
2. (Set the port through which the Emails are sent)
3. abcd...@xyz.net1
4. D:\Inetpub\mailroot\Pickup (Specifies the Pickup Directory for the local SMTP Server)
5. 0
6. abcd...@xyz.net
7. MHTML
8.
9. True
10.

All the above config keys are mandatory for subscribing mails from the reporting services.


No comments:

Back to Top


 

Labels