[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

SQL cdosys mail

Posted on 2011-02-28
2
Medium Priority
?
716 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 2000 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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

650 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