Solved

How do I enable the xp_sendmail in SQL 2005 Server?

Posted on 2007-11-20
6
5,279 Views
Last Modified: 2008-05-01
How do I enable the xp_sendmail in SQL 2005 Server? Thanks
0
Comment
Question by:yong_wu
  • 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

911 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now