Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 xp_sendmail

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-20 : 09:48:01
Jayakumar writes "I have installed Mail server in my machine and it was working fine, all of a sudden xp_sendmail is not working when i use
xp_sendmail in Query A as xp_sendmail @recipients='..','@subject='...'

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.


Can you please give me some guidlines to solve this problem,

Thanks"

efelito
Constraint Violating Yak Guru

478 Posts

Posted - 2002-03-20 : 10:05:30
Log on to the Server using the same account that the SQL Server Agent service uses to connect. Configure the mailbox for this account in the control pannel. Run MS Outlook and set it as the default mail client if it asks. Log out and try xp_sendmail again.

Jeff Banschbach
Consultant, MCDBA
Go to Top of Page
   

- Advertisement -