errors setting up SQL Mail

I get the following error when I test my SQL Mail configuration. MS Outlook is the default mail client so I'm not sure what else could be wrong:

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

Thanks.
JoeI know there was a bug with the length of a profile - how long is your profile ? Also, have you started the mail service using xp_startmail ? When are you receiving this message ?|||From Ent Mgr / Support Services / SQL Mail / properties I type in what I think is the profile (DBA). (I have set up a mail account in Outlook called DBA.) I get the error when I press the TEST button.

What mail service are you referring to and how do I knkow if it's running?|||More info:

When I bring up the SQL Mail/propertes I should see a drop down menu with all the profiles listed. I don't see anything listed even though I have created a profile. This appears to be my problem - why isn't SQL Mail recognizing the profile I created in Outlook?

I can send and receive email thru Outlook just fine.|||I just bounced the MSSQLServer service and the following profile appeared in the drop down list in SQL Mail/propertes: "Microsoft Outlook Internet Settings". The test button then worked. I'm not sure why the DBA profile doesn't appear but I think I may be ok.

Error18025:xp_test_mapi_profile failed with mail error0x80040111

Hi,

I configured the Sql server agent to start with local system and made a profile in intenet mail as SQLMail (Did not used Outlook or Excahnge Server used ar inbox on desktop (Windows messaging system) and internet mail, sendmail which we are having in house), When I tried to Configure SQL Mail for sql server and test , it is ginving the following error.

Error18025:xp_test_mail_profile failed with mail error 0x80040111

:mad:Hello,

i have the same Problemes, how you described it.

Did you start the mail Session?

Have a look on this:
USE master
EXEC xp_startmail

Please enter this brackets in Sql Query and start them.

My Problems already exists. I have problems in sending an e-mail if a error occurs by excuting jobs.

Bye
Harald Bothner|||Ok fellows...

There goes the answers to both of you.

1- Error18025:xp_test_mapi_profile failed with mail error0x80040111

The SQL Server relies in the MAPI libraries to send email messages. Unfortunately, it works at its best allied with Exchange, wich you seem to do not have. But it also works with a pop3 box, leaving the inconvenient need of requiring an Outlook open to get and send messages, and you would have to manage it manually.

Try to use Exchange. If you cant, try using CDONTS. Take a look at the link bellow:
http://support.microsoft.com/default.aspx?scid=kb;en-us;312839

2- mail problems by using sql server

It seems to me that you have not configured the SQL Mail Agent, wich is used by the SQL Server Agent to send notifications about alerts or job status etc.
Take a look at the properties of your SQL Server Agent and see if the email profile is set properly. If its not, just set it and then restart the SQL Server Agent and youre done.