microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Issues with sql mail in SQL 2000

Subject: Re: Issues with sql mail in SQL 2000
From: Joe Webb
Date: Wed, 15 Aug 2007 04:26:45 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Check the Outlook configuration. There are plenty of good KB articles that
describe how to set it up. It may be that there are multiple profiles and
the default one is not the one SQL Server should use. Also check to make
sure that the send immediately option is checked. And finally, ensure that
the service account has sufficient permissions to send email through
Exchange.

AS Todd mentioned, I've used this solutions in production for years. It
works great. http://www.sqldev.net/xp/xpsmtp.htm 

HTH...

Joe



On Mon, 23 Jul 2007 09:04:07 -0700, Todd C wrote:

> Hello Jack:
> 
> If you can, upgrade your SQL to 2005. The advantages are significant, but 
> the one you will be most interrested in is that SQL 2005 does NOT rely on 
> Outlook for mail. It uses SMTP.
> 
> Failing that, if you still need to stay on SQL 2000, but are willing to use 
> a solution that by-passes Outlook and goes through SMTP, do a google search 
> on xp_smtp_sendmail. IT is a free utility / extended stored procedure that 
> you can download and install fairly easily. We used it for a couple of years 
> until 2005 came out.
> 
> HTH

-- 
Joe Webb
SQL Server MVP
http://www.sqlns.com

<Prev in Thread] Current Thread [Next in Thread>
  • Re: Issues with sql mail in SQL 2000, Joe Webb <=