RDS SQL Server DB Mail Configuration

Question

Hi ,

We are doing the AWS SQL Server assessments- in the SCT report, I have received the DB Mail configuration not fully supported in AWS and suggesting the use of the SNS services. Can we can use the on-premises SMTP while configuring the DB Mail for the RDS SQL server or do we need to use only AWS SNS(or SES).

Answer

RDS SQL uses something called sp_send_dbmail to send emails.  
This can also be used with on-premise SMTP servers.  
https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-send-dbmail-transact-sql?view=sql-server-ver16

Also, the following document uses SES in the example, but I believe it is possible to send mail by setting up on-premise SMTP server information.  
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.DBMail.html

RDS SQL Server DB Mail Configuration

Relevanter Inhalt