|
|
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
Navigation:
[Reply to this message]
|