I know this is old but the SQL server I am working on is using xp_smtp_sendmail to send emails via SQL. I have not used this before so I don't know how that works. I did find dbo.xp_smtp_sendmail in Extended Stored Procedures so probably a dll was downloaded.
The issue is it has stopped working since we changed a password of the "From" address in our network provider account. Is there any change I need to make in the SQL server end when the password changes? As an example I ran
@TO = 'email@example.com',
@from = 'firstname.lastname@example.org',
@message = 'ytfuytfuyfuy hguyg',
@subject = 'test email',
@server = 'smtp.ourdomain.com'
I get the error:
Error: sending message
Server response: 503 you must authenticate first (#5.5.1)