SQL cdosys mail

Posted on 2011-02-28
Medium Priority
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

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
Question by:EWHTLC
LVL 75

Accepted Solution

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

Author Comment

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

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
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.

621 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