Hi,
I have problems with sending mails within clustered MS SQL Server 2000.
I configured mail profiles on both nodes (with the same name) - I can send
mail within MS Outlook (which is a default mail client).
There is no profile on drop down list in SQL Mail section (server
properties).

When I execute a statement:
master.dbo.xp_sendmail

I got this:
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.

The sqlservice user is a domain user and computer local administrator.


Is this problem related with clustering or "just" with mailing within SQL
server?


Kind regards.

Hi

Did you log in with the domain account that SQL Server runs under to
configure the mail, then logged off and then logged on again?
Did you configure the correct profile under Support Services > SQL Mail in
EM?

MS does not support mail on clusters, but we have it working well on ours.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike (AT) epprecht (DOT) net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Curious" <curious (AT) email (DOT) com> wrote

Hello
xp_sendmail is not supported on Cluster SQL Server.
Below is a KB that talks about that.
http://support.microsoft.com/kb/298723/EN-US/

As an alternative you can use sp_send_cdosysmail.
http://support.microsoft.com/default...312839&sd=tech
--
Carlos Eduardo Selonke de Souza
http://carlos.geekbunker.org


"Curious" wrote:

As I can see mailing works for SQL Agent Service, which I restarted.
I am unable to restart SQL Service at the moment (production server) -
probably it will help for xp_sendmail procedure too.
Regards


U¿ytkownik "Mike Epprecht (SQL MVP)" <mike (AT) epprecht (DOT) net> napisa³ w
wiadomoœci news:OXPjEZwWFHA.2128 (AT) TK2MSFTNGP14 (DOT) phx.gbl...