yong_wu
asked on
How do I enable the xp_sendmail in SQL 2005 Server?
How do I enable the xp_sendmail in SQL 2005 Server? Thanks
ASKER
What I mean is the sp_sendmail is disable by default for SQL 2005, and how to enable the it in SQL 2005? Thanks
You have to go to the management node in Management studio and under Database mail section confgure.
ASKER
What I should do with the following error message:
Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2007-11-20T10:36:50). Exception Message: Cannot send mails to mail server. (The remote certificate is invalid according to the validation procedure.).
Message
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2007-11-20T10:36:50). Exception Message: Cannot send mails to mail server. (The remote certificate is invalid according to the validation procedure.).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It is already windows Authentication
HTH