Viewing 3 posts - 1 through 4 (of 4 total)
Nita,
Thank you very much for your help. I found that was my spelling typo on name of profile. dumb me 😉
December 3, 2007 at 5:27 pm
#756748
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:43 pm
#756664
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...
December 3, 2007 at 1:07 pm
#756647