How to configure Sql mail
Posted on 2008-11-13
We are using SQL 2000 SP 4 on one of our test servers, sql mail has never been configured by the DBA who has now left.
Microsoft Exchange client is installed and outlook is set as the default client and profile when I look in Control Panel Mail. However there is no email accounts set up and this is the same on our live servers which are working.
in Sql Agent we have Outlook as the Mail profile and I can test on that and get a successful session.
The account is a domain account and is setup on the exchange server as email@example.com
when I go down to SQL Mail configuration, select Outlook (whcih is the profile name setup) I get the follwoing 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 a the default Mail Client.
I ran the sql query statement xp_startmail and got the result below:
Server: Msg 18030, Level 16, State 1, Line 0
xp_startmail: 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.
It consultants assure me that Microsoft Outlook 2000 is the default client.