SQL Mail - MAPI profiles on Windows Server 2003

[Larry Bertolini]

Scenario:
DBMS: SQL Server 2000
OS: Windows Server 2003

Goal:
Enable SQLMAIL via Internet Mail

Problem:
How do I set up the MAPI profile for the SQL Server service account?

On Windows 2000 Server, I can use "Control Panel"/"Mail" to
create a MAPI profile for the SQL Server service account, and then
reference that profile for SQLMAIL in SQL Server and SQL Server Agent.

But on Windows Server 2003, there is no "Mail" applet in "Control Panel".

How do I create a MAPI profile, for the SQL Server service account,
on Windows Server 2003?

[Tony Sebion]

Re: SQL Mail - MAPI profiles on Windows Server 2003

You need to install a MAPI client like Outlook to get that icon and be
able to configure a mail profile.

Good luck,
Tony Sebion

"Larry Bertolini" <bertolini.1@os u.edu> wrote in message
news:dgf8n4$fo8 $1@charm.magnus .acs.ohio-state.edu:
[color=blue]
> Scenario:
> DBMS: SQL Server 2000
> OS: Windows Server 2003
>
> Goal:
> Enable SQLMAIL via Internet Mail
>
> Problem:
> How do I set up the MAPI profile for the SQL Server service account?
>
> On Windows 2000 Server, I can use "Control Panel"/"Mail" to
> create a MAPI profile for the SQL Server service account, and then
> reference that profile for SQLMAIL in SQL Server and SQL Server Agent.
>
> But on Windows Server 2003, there is no "Mail" applet in "Control Panel".
>
> How do I create a MAPI profile, for the SQL Server service account,
> on Windows Server 2003?[/color]

[Simon Hayes]

Re: SQL Mail - MAPI profiles on Windows Server 2003

Larry Bertolini wrote:[color=blue]
> Scenario:
> DBMS: SQL Server 2000
> OS: Windows Server 2003
>
> Goal:
> Enable SQLMAIL via Internet Mail
>
> Problem:
> How do I set up the MAPI profile for the SQL Server service account?
>
> On Windows 2000 Server, I can use "Control Panel"/"Mail" to
> create a MAPI profile for the SQL Server service account, and then
> reference that profile for SQLMAIL in SQL Server and SQL Server Agent.
>
> But on Windows Server 2003, there is no "Mail" applet in "Control Panel".
>
> How do I create a MAPI profile, for the SQL Server service account,
> on Windows Server 2003?[/color]

You need to install a MAPI client, like Outlook.

http://support.microsoft.com/kb/263556/

See the Additional Information section of that article for other useful
links.

If you don't want to install a MAPI client (or if your organization's
build standards don't allow it), then this is a popular alternative:

http://www.sqldev.net/xp/xpsmtp.htm

Simon

[laurenq uantrell]

Re: SQL Mail - MAPI profiles on Windows Server 2003

Ok, a dump question... This approach requires a seperate application
that provides the SMTP server or is that part of SQL Server 2000?

[Simon Hayes]

Re: SQL Mail - MAPI profiles on Windows Server 2003

You need a separate SMTP server to handle the emails - MSSQL itself
doesn't do that; most email servers support SMTP, so you may be able to
use your organization's existing server. Many companies find it useful
to have SMTP available for applications (including MSSQL) to use, since
it's a well-established standard and there are plenty of client
libraries available.

Simon

[Stu]

Re: SQL Mail - MAPI profiles on Windows Server 2003

Note that SQLMail and SQLAgentMail are two seperate (but similar)
processes. SQLMail can be replaced using xp_smtp_sendmai l as described
by Simon below; however, there is no current replacement for the
SQLAgentMail functionaility. You'll have to use a MAPI client like
Outlook to build a mail profile.

Thankfully, this changes in SQL 2005.

Stu