| Author |
Set up SQL Mail on SQL Server 2000
|
|
| Joe K. 2006-10-24, 6:31 pm |
|
I have set up SMTP relay server on a separate server. What are the
procedures that I need to apply to SQL Server 2000 Enterprise Edition to
use this SMTP relay server to route error messages to a group windows account
when SQL Server jobs abort?
Must I install exchange client on each server that I will set up SQL Mail on
SQL Server?
Thank You
| |
| Tibor Karaszi 2006-10-24, 6:31 pm |
| SQL Mail means SQL Server uses MAPI calls. So you need MAPI installed on the SQL Server machine. I
recommend Outlook 2000, I've had problems with the later versions. In short:
Install Outlook
Login as the SQL Server service account
Create the MAPI profiler
Use EM and tell Agent to use that Profile
Make sure that Agent and SQL Server uses the same service account.
Or, use xp_smtp_sendmail from www.sqldev.net.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"Joe K." <Joe K.@discussions.microsoft.com> wrote in message
news:E145FD58-7E73-4F38-9B7D- 558ACA02B8F2@microso
ft.com...
>
> I have set up SMTP relay server on a separate server. What are the
> procedures that I need to apply to SQL Server 2000 Enterprise Edition to
> use this SMTP relay server to route error messages to a group windows account
> when SQL Server jobs abort?
>
> Must I install exchange client on each server that I will set up SQL Mail on
> SQL Server?
>
> Thank You
>
>
| |
| pravin.nagarajan@gmail.com 2006-10-24, 6:31 pm |
| If its just Mail that you want to send using your SMTP server there are
multiple ways to send.I found the following two very useful
1.smtpsend -- http://www.swsoft.co.uk/smtpsend/readme.txt
2.CDONTS -- http://support.microsoft.com/kb/311231/en-us
Joe K. wrote:
> I have set up SMTP relay server on a separate server. What are the
> procedures that I need to apply to SQL Server 2000 Enterprise Edition to
> use this SMTP relay server to route error messages to a group windows account
> when SQL Server jobs abort?
>
> Must I install exchange client on each server that I will set up SQL Mail on
> SQL Server?
>
> Thank You
|
|
|
|