I have setup SQL Server Agent to use an Outlook Mail profile. 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.
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.
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
