July 16, 2008 at 12:38 am
Hi,
I got this message when I was trying a test job to send email to my address:
Executed as user: Test\SQLService. 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. [SQLSTATE 42000] (Error 17930). The step failed.
I have configured SQL Mail in 2005 and also tested it, by right clicking database mail and send test mail(under management).
I have also attached the screen shot when tried to get the properties of sql mail.
thanks:)
July 16, 2008 at 3:41 pm
Be aware that in SQL Server 2005, xp_sendmail is deprecated but still supported, the recommendation is to use Database Mail. I have no idea if xp_sendmail still works in SS 2008, so you might want to update your code.
Check out the BOL entry for more info.
That being said, I don't have a specific answer for you, sorry! Hopefully one of the brilliant 2005 people will step in and help you. 😀
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
July 16, 2008 at 10:30 pm
thanks, Wayne for the valuable information!!
July 19, 2008 at 11:44 pm
The database mail in sql 2005 is a good feature to send mail. I configured a job to send mail through it, upon success or failure. Just loved the feature.
The SQL Mail problems, that we faced in SQL Server 7.0 and 2000, are no more. SQL Server 2005 supports and uses SMTP email now and there is no longer a need to MAPI client to send email!!:)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply