SQL Mail

5 May 2006 8:23 AM

20302807

Hi

i'm running sql 2000 and when i'm trying to start the sql Mail its gives me this error xp_test_mapi_profile: Either there is no default mail client or current mail client cannot fullfill the messaging request.Please run microsoft outlook and set it as a default mail client.

i loaded the outlook and set it as default but still its gives me the same error i dont know what to do now, i searched on the internet for the error number 18030 but i didnt found any solutions. Any help will be much appreciated

thanks
Sandile -- 20302807 ------------------------------------------------------------------------ 20302807's Profile: http://www.dbtalk.net/m293 View this thread: http://www.dbtalk.net/t304525

5 May 2006 12:25 PM

Keith Kratochvil

Do you need to use SQL Mail or will an alternative work for you?

The alternative is XPSMTP
http://www.sqldev.net/xp/xpsmtp.htm

If you need SQL Mail, you need to log in to the SQL Server box as the
Windows user that the SQL Server services are running under. You need to
set up the mail profile as that user in order for SQL Server to be able to
see the profile.

--
Keith Kratochvil

Show quote

"20302807" <20302807.27b***@no-mx.forums.yourdomain.com.au> wrote in message
news:20302807.27bu20@no-mx.forums.yourdomain.com.au...
>
> Hi
>
> i'm running sql 2000 and when i'm trying to start the sql Mail its
> gives me this error xp_test_mapi_profile: Either there is no default
> mail client or current mail client cannot fullfill the messaging
> request.Please run microsoft outlook and set it as a default mail
> client.
>
> i loaded the outlook and set it as default but still its gives me the
> same error i dont know what to do now, i searched on the internet for
> the error number 18030 but i didnt found any solutions. Any help will
> be much appreciated
>
> thanks
> Sandile
>
>
> --
> 20302807
> ------------------------------------------------------------------------
> 20302807's Profile: http://www.dbtalk.net/m293
> View this thread: http://www.dbtalk.net/t304525
>