Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-29 : 08:44:41
|
| dave writes "Our email backup notifications on 2 of our SQL servers have failed on us (they were working at one point). A 3rd SQL server has been recently set up to send backup notifications and is also failing. I have configured all 3 SQL 2000 servers with an Internet Profile (POP3) using the Outlook 2000 Client. I am able to send and recieve email INITIALLY. I can create test backup jobs and have notifications of completion sent to me successfully. Intermitently when I log off and then back on the machine and test the Outlook client or SQL email configuration I receive:error 22022: SQLServerAgent Error: The C:\Documents&Settings\%username%\outlook.pst could not be accessed because another workstation has modified it.When this happens it appears as if the SQL agent has a lock on the .PST and nothing works, including Outlook. Restarting the SQL services seems to let it go.I also receive an error in the event log:Event ID: 210 Unable to send job completion notification email to operator.When I remain logged in as the user in which I've created the OUtlook profile all seems to work. I guess a quick fix would be to stay logged in as the user and lock the machine. However this is not a long term solution sicne there are multiple users that need to log oon and off of these machines.I am unable to find anything on this, all help is appreciated." |
|
|
ESBertrand
Starting Member
1 Post |
Posted - 2004-02-27 : 10:16:24
|
| Hi All.We have this problem as well. We're getting the first error message when trying to send a test e-mail to an operator. The "test" buttons within SQLMail properties and SQLServerAgent properties work fine. I had this working once but it has stopped again, probably due to the same behavior described above.Any thoughts anyone?Erik |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-02-27 : 12:35:33
|
| I have received this error message before when we configured SQL Mail using Internet mail. Doing it that way, you can't open Outlook on the machine ever. So reboot the server to release the file, then try out SQL Mail.Tara |
|
|
|
Lobmeyer
Starting Member
1 Post |
Posted - 2006-07-11 : 09:19:16
|
| Use XP_SENDMAIL to see what the actual error you are getting is. In my case it didn't want to send to a distribution list that I picked from the Drop down. When I put in the fully qualified name for the distribution list all started working again.SQL Server Enterprise Manager -> Server Group -> Server -> Management -> Operators -> Name - Support (From example) -> Properties -> General Tab -> E-mail NameFor me this broke after the Upgrade to W2K3 and AD. I was on a NT4.0 Domain with Exchange 5.5 and it worked fine. After the upgrade of all the Servers to W2K3 it broke. I think it has something to do with the distribution group.For Example:Problem Distribution List was SupportWhen I entered Support@MyDomain.com the emails and all the alerts started working again. Also as another check you may want to delete the Mapi Profile and recreate it.Good Luck! |
|
|
|
|
|
|
SQL Mail Problem