SQL Mail not working

Question

SQL Mail not working

lucky-80472

SSCertifiable

Points: 7793
More actions
September 6, 2006 at 7:14 am

#62038

Hello,
I'm having a SQL 2000 box (SP4) with mail profile configured on the server, but no mail is being sent for any job when it fails. I have created an operator and could send the test mail to self without any problem but it is not working as part of the notifications from the job. The error message it is giving out is as follows:
Executed as user: domain\login. xp_sendmail: failed with mail error 0x80040111 [SQLSTATE 42000] (Error 18025). The step failed.
Not able to figure out the root cause for the problem.
Appreciate any suggestions.
Thanks

Lucky

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Sreejith Sreedharan SSCertifiable Points: 5403 More actions · Answer 1

Is the SQL Agent set to startup using a domain account? IF you so you need to logon to SQL Server with that account and configure "OUTLOOK" profile. xp_sendmail uses the profile set up fot the account that SQL Server starts with and Job Failure Notifications is based on the account that runs SQL Agent.

Hope this helps.

Thanks

Sreejith

Randy Doub SSCertifiable Points: 5322 More actions · Answer 2

Google "xp_smtp_sendmail". Its an extended stored procedure that uses SMTP for mailing from SQL Server. Its a beautiful thing. You'll never need a MAPI client on your SQL Server again. There is a SQL 7.0 and 8.0 version and comes with installation instructions. I use it all over the place and never have a problem.

sqldba-294117 Hall of Fame Points: 3486 More actions · Answer 3

check the Email profile if some thing as changed & also coordinate with Exchange Admin to make sure that nothing as changed from there ends.

Thanks

David Diener SSC-Addicted Points: 410 More actions · Answer 4

Try a test by leaving the Outlook MAPI client open and minimized on your SQL Server box, then do a notificaiton test.

Kindest Regards,

(Anonymous) SQL Server DBA

alen teplitsky SSC-Dedicated Points: 30014 More actions · Answer 5

sqlmail is the most evil thing that exists and i cannot wait until we go to sql2005. i don't care about all the gee whiz things in it except that there is no more sqlmail.

install outlook 2000 on your sql server. set up profile and open the mailbox via outlook. type in profile name in support services > sql mail. default is MS Exchange Settings or you can look in the mail icon in the control panel. restart SQL Server service or reboot your server. it should work.

balde SSCommitted Points: 1594 More actions · Answer 6

Ensure MSSQLSERVER and SQLSERVERAGENT services log on using the same account ("Domain\User")

Install MS Outlook

Log on to PC as "Domain\User"

Open Outlook and Configure exchange settings

Open Enterprise Manager and right-click on SQL Server Agent. Select Mail Profile "MS Exchange Settings" (after restarting SQL Server Agent)

Randy Doub SSCertifiable Points: 5322 More actions · Answer 7

The last post by blade is exactly what you need to do if you're using Outlook.

Or try SMTP mail. Job Step 1 executes whatever. On success it quits reporting success. On failure, it goes to step 2 which sends you an email telling you your job failed. All my jobs do this and I have no Outlook, no MS Office update/upgrade reboots and no 'job completed but didn't send mail' mysteries. I'm telling you, xp_smtp_sendmail is the DBA's best friend.

tosscrosby Hall of Fame Points: 3140 More actions · Answer 8

Randy,

Do you know how to send to multiple people? I've also e-mailed Gert to see if I can get some help. I've tried the usual separtors (, and . It runs fine be the email doesn't go through. It doe work with one email address.

Terry