SQL Mail

Question

Post reply

SQL Mail

David Hammond

Valued Member

Points: 72
More actions
March 16, 2005 at 12:37 am

#87856

My background: MAJOR SQL noob..
ok, i've somehow found myself in charge of a few sql machines. So I have been ploughing through as much docco as I can. Ive also setup a test box which I can 'break'.
ok.. Ive setup maintanence plans, backups etc. Now I want sql to email me when theyre succesfully and to alert me of other events.
I have read through the books online section on sql mail and I have installed a mail client on my server (outlook 2003), created a mail profile, tested the account etc. But I cannot add the profile to sqlmail within enterprise manager.
I have just read on a site that outlook 2002 doesnt work for some reason..
does anyone know if outlook 2003 is compatable? If not.. are there any other mail clients I can use to enable mail within sql?
Is there an easier way to issue alerts via email? I looked at Blat a while ago but I wouldnt have a clue on how to setup the scripts/commands to get sql to info to it
got any ideas?

Viewing 5 posts - 1 through 4 (of 4 total)

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

David Hammond Valued Member Points: 72 More actions · Answer 1

after doing some more searching on these forums ive found some info! (yes, I know, I should of done it first )

quote:

If not I'd suggest you save yourself some headaches and use xp_smtp_sendmail from http://www.sqldev.net

Removes the requirement of Outlook installed and running on the server. It also avoids issues that arise when your Exchange server is not available.

More info here:

http://www.dbmaint.com/SmtpAlerter.asp

Gregory W Pfeifer Valued Member Points: 71 More actions · Answer 2

When setting up my SQLMail, I found that the email account and the SQL Server Startup Service Account must be the same owner.

Brian Laws SSCommitted Points: 1556 More actions · Answer 3

I was just researching this yesterday and found on Microsoft's site that you have to use Outlook 2000 or Exchange Server to use the built-in SQL Mail. Outlook 2003 won't work.

Check out the following:

http://support.microsoft.com/default.aspx?scid=kb;en-us;263556

http://support.microsoft.com/default.aspx?scid=kb;en-us;311231

http://support.microsoft.com/default.aspx?scid=kb;en-us;315886

But if you don't want to use SQL Mail, then you can use CDO or CDONTS in a stored proc to send email (if you have SMTP installed on the server). But SQL Mail is required for automatic alerts and the like through SQL Agent.

Deborah Nitz Newbie Points: 3 More actions · Answer 4

I have battled with SQL Mail for more than a year now. We do not use Microsoft Exchange Server. We are using POP3 and Outlook 2000. SQL Mail is flaky and difficult to deal with as I am sure you are finding out. It is even worse in the clustered environment but I currently have it working. I have some documentation (Word and text documents if you are interested).

dnitz