SQL mail using external mail server

SQL Server Tools General

Marcelroos


Hello

We are using SQL Server 2000 SP4 Standard Edition and would like to use the e-mail function to monitor certain alerts. However, an e-mail server (SMTP server) is not installed on that box, but on a different IP address within the network.

I have set up the e-mail operator, enabled e-mail in SQL Agent and set the Mail Configuration in Support Services. However, on testing I get the following error :

Error 18030: xp_test_mapi_profile : Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client.

As I cannot install Outlook on this server, I am now stuck.

Has anyone a suggestion how I can overcome this issue

Thanks,

Marcel

Top

Re: SQL mail using external mail server

Satya SKJ


Check if your SQL Server service running in the security context of a user account with administrative previleges or system account.

Make sure you have logged on to the server as the service account user and created a messaging profile for outlook. After applying the service account settings, restart the SQL Server Service.



http://support.microsoft.com/kb/312839 send email without using SQLMail.






Top

Re: SQL mail using external mail server

Maciek Sarnowicz MSFT

In addition to the above, the following KB links may be helpful:

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

http://support.microsoft.com/kb/321183/en-us

http://support.microsoft.com/kb/870675/en-us

but in essnce, if you cannot install Outlook on that machine then you need to look for an alternative solution. Note that SQL Server 2005 provides an e-mail component that uses SMTP and does not rely on Outlook or any other MAPI client.

Regards,

Maciek Sarnowicz



Top