SQL server 2005 Reporting services SMTP Email delivery issue

We have SQL server 2005 Reporting services, we are making use of local SMTP for relaying.

I am able to send mails using Telnet, but when we enable subscriptions on reports we get
Failure sending mail: Access is denied. error message, I checked in the log


ReportingServicesService!emailextension!f!05/22/2009-15:26:14:: Error sending email. System.UnauthorizedAccessException: Access is denied.

   at ReportingServicesCDOInterop.MessageClass.Send()
   at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!notification!f!05/22/2009-15:26:14:: Notification 9f7bd5f3-0a3c-4461-8c5b-6ed0da20acdb completed.  Success: False, Status: Failure sending mail: Access is denied.
MNASAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mfreudenCommented:
in the reporting services mail config screen, try putting a known working username / password as the username/pw to connect to the mail server.  It's definelty security related.
0
MNASAuthor Commented:
In the reporting services mail config screen we are not able to put user name and password, it just accepts the from and smtp server details.
0
MNASAuthor Commented:
it was problem of access right on the SMTP mail pickup directory.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.