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

Set up MSSQL using the RDS service in AWS

In this article, we will set up MSSQL using the RDS service in AWS.

What is the RDS?

RDS (stands for Relational Database Service) is used to set up, operate or scale the relational database.

Prerequisite

Before you start the MSSQL set up, these conditions must be fulfilled.

The region in which RDS will be created should have at least 2 subnets.
Subnets are mapped to atleast 2 Availability Zones.
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?

To create a RDS, search the word "RDS" in the search box.

Picture showing the RDS option in the search result

Click to Enlarge

The RDS screen will appear. Click on the "Create database" button.

Picture showing the Create database button for creating the new database

Click to Enlarge

The create database screen will appear. First, select the database creation mode.

Picture showing selecting the database creation method in RDS

Click to Enlarge

Scroll down to select the "Engine type" and "DB instance size". For this article, we will select "Microsoft SQL Server" as "Engine type" and "Free tier" as "DB instance size".

Picture showing selecting the engine type while creating a new database

Click to Enlarge

Scroll further down to enter the database name and credentials.

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

Click to Enlarge

Scroll to the bottom and click on the "Create database" to create the database.

Click to Enlarge

Database status

Once the database is created, the status of the database is "Creating".

Picture showing the status of database as Creating

Click to Enlarge

Once the status is changed to "Available", you can connect to the database.

Picture showing the status of database as Available

Click to Enlarge

Please note that it may take 20-25 mins to change the status from "Creating" to "Available".

Database configurations

Once the database is available, you can check the following

Endpoint
"Publicly Accessible" should be set to "Yes".

Picture showing the Server endpoint and Publicly Accessible attribute of the database

Click to Enlarge

If the value of "Publicly Accessible" is "No", you can modify the database and change the public access.

Picture showing the setting to enable Publicly Accessible

Click to Enlarge

Connect to the database

For connecting to the database, use the following credentials

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

The database will be connected.

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/Feedback	Characters remaining 250