I am trying to use the example at http://support.microsoft.com/default.aspx?scid=kb;en-us;312839
to send email from SQL Server (2000) using CDOSYS. I have no idea what CDOSYS is, but in the example, it says to replace 'cdoSMTPServerName' with the name or IP address of my smtp server. I did that and received an error message that 'The server rejected the sender address. The server response was: 530 authentication required - for help go to...'
Is there a way that I can add the authentication required? In my email account settings, I have checked that the server requires authentication and to use the same settings as my incoming mail server if that helps.