By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

RDS SQL Server DB Mail Configuration

0

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).

Topics
Database
Tags
Microsoft SQL ServerDatabaseSQL MigrationsAWS Schema Conversion Tool (AWS SCT)RDS Custom for SQL Server
Language
English
Sanjeev_K
asked a year ago596 views
1 Answer
0

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

profile picture
EXPERT
Riku_Kobayashi
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content