Solved

xp_sendmail fails sql 2000

Posted on 2015-01-09
3
110 Views
Last Modified: 2015-01-09
We changed the ip address of our exchange server yesterday, now we have error xp_sendmail: failed with mail error 0x80040115   How can we address this?
0
Comment
Question by:spoye
[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
  • 2
3 Comments
 
LVL 19

Expert Comment

by:strivoli
ID: 40540187
You should setup SQL Mail in order to set the new mail server address. The problem is: SQL is pointing to the old address.
0
 

Author Comment

by:spoye
ID: 40540202
We have not done this where do we set this up enterprise manager?
0
 
LVL 19

Accepted Solution

by:
strivoli earned 500 total points
ID: 40540222
This should help.
0

Featured Post

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.  

Question has a verified solution.

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

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

724 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