SQL Server Agent - sending mail problems with Outlook

  • I have setup SQL Server Agent to use an Outlook Mail profile with POP3, not Exchange.  When I created the mail profile, I used the same domain account that the SQL Server Agent runs under.  I believe everything was working and now I have some problems.

    Right now I can successfully start and stop a mail session by doing the test within SQL Server Agent Properties.  However, if I send a test email to an operator or if one of my SQL Server Agent job fails I am not being notified.

    If I log into the server with the domain account SQL Server Agent is using and open Outlook I receive the following error message:  "Unable to open your mail default e-mail folders.  The file C:\....\outlook.pst is in use and could not be accessed.  Close any application that is using this file, and then try again."

    If I stop the SQL Server Agent and I re-open outlook, I do not receive any error messages and I will receive my test messages that I had previously sent from SQL.

    It appears there is a conflict between the SQL Server Agent and Outlook.  I tried creating a new mail profile and setting up SQL to use that with no luck.

  • While this means setting up some things manually I recommend downloading and using SMTP Send Mail which is available at http://sqldev.net/xp/xpsmtp.htm.  I have had multiple problems using SQL Mail and SQL Agent Mail, but this far SMTP Send Mail has been bullet proof.

  • I think I renamed the .pst file, and then it created a new one which fixed the problem.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply