RDS Database Setup

The following steps should be started right away to minimize the amount of time you spend waiting for these services to initialize.

We are going to be using a Microsoft SQL Server database in this lab.

  1. Start by logging into the AWS Console.
  2. On the AWS management console home page, search for “RDS” in the “Find Services” search box. Press enter or click the “RDS” service that populates in the fast search.
  3. From the “RDS dashboard,” click the “Create database” button.
  4. On the “Create database” page, make the following selections:
    1. Choose a database creation method: Easy Create
    2. Configuration: Microsoft SQL Server
    3. DB instance size: Free tier
    4. DB instance identifier: mssql1
    5. Master username: admin
    6. Auto generate a password: unclick this option
    7. Master password and Confirm password: something you can remember
  5. Click “Create database”
  6. That will take you back to the “Databases” page. Click the “mssql1” link under “DB identifier.”
  7. On the “Connectivity & security” tab under the Security heading, click the link under the “VPC security groups”
  8. That will take you to the security group details. click the “Inbound” tab > “Edit.”
  9. Add an “All traffic” entry and allow traffic from 0.0.0.0/0. Click Save.
  10. Move on to the next instructions while the database is created. We will use the database one we have the rest of the components setup.