xp_sendmail error msg 18030

Question

Post reply

xp_sendmail error msg 18030

Ails

SSC Enthusiast

Points: 166
More actions
January 26, 2006 at 5:57 am

#90662

Hi!
I'm not sure whether this is the right place to post this, but I'm getting a frustrating error when trying to implement a stored procedure to send a mail using xp_sendmail. When I try to execute the procedure from within SQL Server, I am getting the following error:
Server: Msg 18030, Level 16, State 1, Line 0
xp_sendmail: 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.
I have copied most of a procedure that was already in place, written by someone else a couple of years ago, so it should work.
Maybe it has something to do with my account settings - that i don't have access to use sendmail?
Not sure how to go about fixing this - any help appreciated!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

jordanac Hall of Fame Points: 3653 More actions · Answer 1

Hi,

Using Enterprise Manager click on support services, right click on SQL Mail.

The SQL Mail Configuration form has Profile Name and test button. What happens if you click the test button?

Andy.

Ails SSC Enthusiast Points: 166 More actions · Answer 2

Hi Andy,

Thanks for your reply. I checked this and there is no profile name listed. But I know this worked before as there are a few procedures in the database that are used to send mail - I just can't execute them without getting that error.

Do I have to be an administrator to view the profile name, do you know?

Thanks!

jordanac Hall of Fame Points: 3653 More actions · Answer 3

The xp_sendmail proc uses SQL Mail if the profile is not set up it cannot work. Have you actually seen the other procs work?

Andy.