SQL Mail

  • 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?

  • 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

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

  • 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.

  • 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

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

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