| Author |
Topic |
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
 Posted - 2003-10-13 : 10:07:37
|
SQL Agent Mail works (in EM, expand Management, SQL Server Agent, Operators, click on operator (Page47) click "test" next to email, I get the email).SQL Mail does not work (xp_sendmail). It gives the following error:quote:
Server: Msg 18025, Level 16, State 1, Line 0xp_sendmail: failed with mail error 0x80040111
Both SQL Mail and SQL Agent Mail use the same MAPI profile. Both SQL Mail and SQL Agent Mail used to work until, because of security reasons, we had to change the service account for SQL and Agent.Any ideas? I've googled and read just about everything on the microsoft site regard the above, that didn't help. I've tried creating new mapi profiles, restarts of the services and reboots of the machine.Jay White{0} |
|
|
OMB
Yak Posting Veteran
88 Posts |
Posted - 2003-10-13 : 10:37:39
|
| Jay This might help http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20178037.html |
 |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-10-13 : 11:09:27
|
| nopeJay White{0} |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-13 : 12:39:56
|
| Does Outlook work when you log into the server using the account that the SQL and Agent log on as? If not, the problem is probably with the profile. Verify the profile in Outlook. Also, does the account have a mailbox on the Exchange server?Are you running at least service pack 2?Tara |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-10-13 : 13:10:14
|
| I am on SQL 2K sp2. When I log onto the server as the startup account I can send mail. The profile seems to be ok in that regard. And, like I said, SQL Server AGENT mail works fine (for example notification on job failure, etc.) .....Jay White{0} |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-13 : 13:25:43
|
| Does this article apply to your environment:[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;327552[/url]Tara |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-10-13 : 13:58:19
|
| I do have a cluster, but both nodes are running with the same service account. And the MAPI profile names are the same.Jay White{0} |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-13 : 14:03:05
|
| Is this with an Exchange server? We've got irregular SQL Mail problems in our clustering environment. We do not have an Exchange server in that environment, we are using Internet mail. MS says that Exchange server would solve our problems. We should be getting one soon.Tara |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-10-13 : 14:24:15
|
| Yep ExchangeJay White{0} |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-13 : 14:47:18
|
| Does Outlook prompt for anything when you log into the server using the startup account?When you run xp_sendmail, are you logged in with the startup account?0x80040111 means MAPI_E_LOGON_FAILED. So something is wrong with the account (password, profile, etc...).Tara |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-10-14 : 07:22:26
|
No. Yes (although, I get the error logged in as anyone).Oddly the error message has changed.quote:
Server: Msg 18025, Level 16, State 1, Line 0xp_sendmail: failed with mail error 0x80070005
Jay White{0} |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-14 : 12:51:13
|
quote:
Originally posted by Page47
Yes (although, I get the error logged in as anyone).
Yes you will get the error for other users as well because they are all using the SQL Mail account (the account that the services use to logon as) and there is something wrong with the account.Have you tried creating another account and reconfiguring everything for this account? Something must have been missed or misconfigured for this account not to work, so try another account. If you switched back to the old account, would SQL Mail work again?Tara |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-10-15 : 07:25:54
|
| Tara, thanks for the suggestions. I have infact already tried all of the things you have suggested. I've opened a ticket with Microsoft.Jay White{0} |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-15 : 14:14:32
|
| Sorry I couldn't help. We have experienced so many SQL Mail problems here. It can be such a pain in the A$S sometimes. It hasn't caused us any problems in quite a while, but I remember before we installed a hotfix that MS had us apply to fix our problems, we were having to reboot the servers because SQL Mail would hang SQL Agent so that we couldn't even run jobs.Let us know what fixes the problem in case we ever come into a similar problem.Tara |
|
|
|
|
SQL Mail