Solved

How do I enable the xp_sendmail in SQL 2005 Server?

Posted on 2007-11-20
6
5,304 Views
Last Modified: 2008-05-01
How do I enable the xp_sendmail in SQL 2005 Server? Thanks
0
Comment
Question by:yong_wu
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 15

Expert Comment

by:spprivate
ID: 20320649
0
 

Author Comment

by:yong_wu
ID: 20320755
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
 
LVL 15

Expert Comment

by:spprivate
ID: 20320844
You have to go to the management node in Management studio and under Database mail section confgure.
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 

Author Comment

by:yong_wu
ID: 20320986
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
 
LVL 15

Accepted Solution

by:
spprivate earned 250 total points
ID: 20321279
Can you check your authentication type? Go to Database mail configuration wizard -> Manage Existing account check the SMTP Authentication. Select the windows Authentication
0
 

Author Comment

by:yong_wu
ID: 20321325
It is already windows Authentication
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to disable/enable multiple sql jobs in efficient way 11 135
Bubble user-defined Sql RAISERROR(...) to c# exception 14 232
Parse this column 6 38
Need to find substring in SQL 5 52
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question