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.

---

SQL Server 2000 Reporting Services Error

Problem: "Provider cannot be found. It may not be properly installed."

Solution: This error occurs because a dynamic-link library (DLL) that is required by the Microsoft Data Access Components is not registered. This resolution uses a SQL Server OLE Provider DLL (Sqloledb.dll) as
an example. Because the unregistered DLL may vary based on the OLE DB Provider that you are using, modify step 2 accordingly.

Reregister the faulty DLL as follows:
1. At the command prompt, change to the C:\Program Files\Common Files\System\Ole DB folder.
2. Type regsvr32 sqloledb.dll
3. Some popup message should display saying that the DLL was registered successfully.
See: http://support.microsoft.com/default.aspx?scid=kb;en-us;278604

---