December 3, 2007 at 12:35 pm
I have two SQL 2K servers using same domain account say SERVER1ACCT. Both servers SQL Mail and SQL Agent Mail used to work. Recently due to company security standard, I have to have second account SERVER2ACCT created to run server2.
I changed service account on server2 to use SERVER2ACCT, Both SQL Mail and SQL Agent Mail use the same MAPI profile. SQL Agent Mail works on server2 but SQL Mail does not work (xp_sendmail, xp_startmail). It gives the following error
Server: Msg 18025, Level 16, State 1, Line 0
xp_startmail: failed with mail error 0x80040111
We use Exchage server and I have the mailbox fully shared by SERVER1ACCT and SERVER2ACCT.
Can anyone help me please? Thanks very much
December 3, 2007 at 12:58 pm
use
exec xp_stopmail
and then
exec xp_startmail
December 3, 2007 at 1:07 pm
I did EXEC xp_stopmail then EXEC xp_startmail. The sp_startmail got
Server: Msg 18025, Level 16, State 1, Line 0
xp_startmail: failed with mail error 0x80040111
Then I restarted SQL server and Agent service. They did not fix the problem.
December 3, 2007 at 1:23 pm
Ask you windows team to authenticate the password with SQL Agent password.
if needed stop and re-start the SQL Agent and then do again xp_stopmail and xp_statmail
December 3, 2007 at 1:43 pm
No use. MSSQLSERVER and SQLSERVERAGENT run under same domain account. Both SQL Mail and SQL Agent Mail use this profile.
December 3, 2007 at 1:51 pm
I had this issue long time ago, after rebotting the server it did worked may be the password is cashed or whatever may be the reason.
December 3, 2007 at 5:27 pm
Nita,
Thank you very much for your help. I found that was my spelling typo on name of profile. dumb me 😉
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply