Create a Database Mail profile (a profile is a container used to store email accounts).Use the following stored procedures to create a simple Database Mail configuration. Connect to the SQL Server engine of the RDS instance that Database Mail is enabled for.User3 has access to Account 2 and Account 3 via Profile 2.īefore we can use Database Mail, we need to set up a mail configuration. User2 has access to all accounts via both profiles. User1 has access to Account 1 and Account 2 via Profile 1. The following diagram illustrates an example Database Mail configuration. Choose Modify DB Instance to apply the changes.Ĭonfiguring Database Mail for an instance in a public subnet.Under Scheduling of modifications, choose Immediately.Under Database options, choose the parameter group that has database mail xps set to 1.On the Amazon RDS console, choose Databases.Choose Edit Parameters to modify the value.In the search box, enter database mail xps.Choose the parameter group you want to use.On the Amazon RDS console, choose Parameter groups.To enable Database Mail through a parameter group, complete the following steps: For more information about creating a new parameter group, see Working with DB parameter groups. If choosing an existing parameter group, it must support your SQL Server instance edition and version. You can either use a new parameter group or an existing created parameter group. Each RDS instance comes with an associated default parameter group however, we can’t modify it. In Amazon RDS, parameter groups act as a container for engine configuration values that are applied to one or more DB instances. Enabling Database Mail through a database parameter groupĭatabase Mail is enabled on an RDS instance through a database parameter group. ![]() Setting up Database Mailīefore configuring Database Mail, you first enable it through a database parameter group. After you confirm your email, Verification Status should show as verified.Īt this point, we have all the necessary information about our SMTP server and can start configuring Database Mail.Enter an email address that you own to receive a confirmation email.On the Amazon SES console, choose Email Addresses.Save the SMTP credentials somewhere safe this is the only time you can download it.Enter a name for your AWS Identity and Access Management. ![]() Refer to Obtaining Amazon SES SMTP credentials to learn more. Note: The credentials that you use to send email through the Amazon SES SMTP interface are unique to each AWS Region.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |