Articles → AWS → Set up MSSQL using the RDS service in AWS

Set up MSSQL using the RDS service in AWS






What is the RDS?





Prerequisite




  1. The region in which RDS will be created should have at least 2 subnets.
  2. Subnets are mapped to atleast 2 Availability Zones.
  3. Add an inbound rule for port 1433 in the security group.
Picture showing adding the inbound rule for 1499 port number in security group

Click to Enlarge


How to create an RDS?




Picture showing the RDS option in the search result

Click to Enlarge



Picture showing the Create database button for creating the new database

Click to Enlarge



Picture showing selecting the database creation method in RDS

Click to Enlarge



Picture showing selecting the engine type while creating a new database

Click to Enlarge



Picture showing adding the database name and the credentails while creating a new database using RDS

Click to Enlarge



Picture showing the Create database button for creating the new database

Click to Enlarge


Database status




Picture showing the status of database as Creating

Click to Enlarge



Picture showing the status of database as Available

Click to Enlarge




Database configurations




  1. Endpoint
  2. "Publicly Accessible" should be set to "Yes".
Picture showing the Server endpoint and Publicly Accessible attribute of the database

Click to Enlarge



Picture showing the setting to enable Publicly Accessible

Click to Enlarge


Connect to the database




Server: sample-database.criatfcnohqo.us-east-2.rds.amazonaws.com,1433
Username: admin
Password: <Created by you>


Picture showing connecting the database using SSMS

Click to Enlarge



Picture showing the object explorer view of the database in SSMS

Click to Enlarge


Posted By  -  Karan Gupta
 
Posted On  -  Wednesday, October 20, 2021
 
Updated On  -  Friday, November 26, 2021

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250