Groups | Blog | Home
all groups > sql server new users > march 2007 >

sql server new users : SQL Mail - No Profile


SAC
3/28/2007 12:00:00 AM
I want to use sql mail, but I don't have a profile.

I have Outlook 2003 installed on the computer with an email account using
exchange server.

In the Control Panel I see a profile named Outlook, but when I attempt to
configure sql mail no profile is listed.

What do I need to do?

Thanks.

Sue Hoegemeier
3/28/2007 8:51:56 PM
If you are on SQL 2005, use Database Mail instead.
For SQL Mail, the last stable version combination of SQL
Mail and Outlook was with Outlook 2000. After that, you hit
some issues. The following articles will walk you through
configuring SQL Mail:
NF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
INF: Common SQL Mail Problems
http://support.microsoft.com/?id=315886

If you aren't on SQL 2005, I think the best configuration
option is to not use SQL Mail and MAPI. You can use SMTP
which is a lot cleaner, not dependent on MAPI profiles, not
dependent on keeping a program like Outlook open and running
(what you need to do with Outlook 2002 and above) on a
server, doesn't flake out like Outlook/MAPI, etc, etc.. You
can download a free xp to do SMTP mail and find more
information at:
http://www.sqldev.net/xp/xpsmtp.htm

-Sue

On Wed, 28 Mar 2007 08:58:22 -0500, "SAC"
[quoted text, click to view]
SAC
3/29/2007 2:01:03 PM
Thanks!
[quoted text, click to view]

AddThis Social Bookmark Button