Solved

SQL cdosys mail

Posted on 2011-02-28
2
711 Views
Last Modified: 2012-05-11
Hi There,
I've been using this metho to send email from stored procedures now for months even years.
So much so that I've forgotten how I actaully set it up.
I know someone told me how.  

exec sp_send_cdosysmail
  'fraommailaddress',
  'tomailaddress',
  'subject',
  'message'  

As I said the process worked fine up until today.
I am now getting an error message in the failures table

Failed at sp_OAMethod Send
The server rejected the sender address. The server response was: 530 5.7.1 Client was not authenticated  

Does anyone know what might have changed.
I am not the system administrator. We have an external Company who may have changed something.

Can anyone help
0
Comment
Question by:EWHTLC
[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 Comments
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 500 total points
ID: 35001981
seems like someone changed the password, you need to check with your system administrator
0
 

Author Comment

by:EWHTLC
ID: 35005958
Yess it turns out someone was tighening up security and I now need to be able to realy messages through my remote server.
THanks for your help
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

726 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