Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5352
  • Last Modified:

How do I enable the xp_sendmail in SQL 2005 Server?

How do I enable the xp_sendmail in SQL 2005 Server? Thanks
0
yong_wu
Asked:
yong_wu
  • 3
  • 3
1 Solution
 
yong_wuAuthor Commented:
What I mean is the sp_sendmail is disable by default for SQL 2005, and how to enable the it in SQL 2005? Thanks
0
 
spprivateCommented:
You have to go to the management node in Management studio and under Database mail section confgure.
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
yong_wuAuthor Commented:
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.).
0
 
spprivateCommented:
Can you check your authentication type? Go to Database mail configuration wizard -> Manage Existing account check the SMTP Authentication. Select the windows Authentication
0
 
yong_wuAuthor Commented:
It is already windows Authentication
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now