Posted by Simon Hayes on 09/16/05 23:41

Larry Bertolini wrote:
> 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?

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

[Back to original message]