March 16, 2005 at 12:37 am
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?
March 16, 2005 at 12:43 am
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:
March 17, 2005 at 7:47 am
When setting up my SQLMail, I found that the email account and the SQL Server Startup Service Account must be the same owner.
March 17, 2005 at 8:13 am
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.
March 17, 2005 at 8:22 am
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