im running SQL 2000 on a windows 2003 server.
we have reporting services running and subscriptions seem to be working with 1 small problem. If you go into the subscription it says that the email was sent to the email address successful. But the email is still in the pickup directory. How come the email is not being sent. I have configured an outlook account on the box and send a test email. i went into sql mail used the profile and ran test and came back successful.
does the SMTP service have to be running on the sql server ?what am i missing any help would be greatly appreciated.
here is the section from the rsreportserver.config
<Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">