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 - 2004-09-03 : 08:28:36
|
| Pat writes "I am having a problem were sql mail will work once but then fail after that until I reboot the server. I am using a SQL Server 2000 and Outlook 2000, with Internet E – Mail and SMTP / POP3 setup. I installed Outlook while logged in under the same account that the SQLSERVER and AGENT services are started with. It is a local system account with admin rights on the server and in sql. When I reboot the server I can go into EM and TEST the Mail Profile in Support Services and in the Properties of SQL Agent successfully. Then I can run an xp_sendmail procedure and it returns: SQL Mail session started. Mail Sent and I receive an email. If I run xp_sendmail again all I get is Mail Sent, no email is delivered and if I go back into EM and try to click TEST for the Mail Profile in either area EM locks up and needs to be killed in Task Manager. I have tried stopping and restarting the Agent service but it doesn’t help and won’t work again until I reboot the server. When the server is rebooted the unsuccessful mail is usually delivered. I have uninstalled and reinstalled Outlook several times and tried two different servers with the same problems. I tried xp_startmail > xp_sendmail > xp_stopmail and the first time after a reboot it works but on the second try it locks up QA and I have to kill it with Task Manager. I have tried leaving Outlook open while running the xp_sendmail procedure without any luck, it hangs also. Any suggestions would be greatly appreciated." |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2004-09-03 : 11:55:17
|
| Try logging in as SQLServer Service account, and send a couple messages through Outlook and see what happens. If you get any knid of dialog box that would cause SQLMail to hang.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-09-03 : 18:40:59
|
| Do you have the latest service packs on Outlook, SQL Server, and Windows? This isn't Windows 2003 is it?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
SQL Mail