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 at least 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 an RDS, search the word RDS in the search box. Click on the RDS service from the search result.

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 instance 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 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

Different Databases And Use Cases

Data Store	When to Use
Database on EC2	Ultimate control over the database Preferred DB not available under RDS
Amazon RDS	Need a traditional relational database for OLTP Your data is well-formed and structured Existing apps requiring RDBMS
Amazon DynamoDB	Name/value pair data or unpredictable data structure In-memory performance with persistence High I/O needs Scale dynamically
Amazon RedShift	Massive amounts of data Primarily OLAP workloads
Amazon Neptune	Relationships between objects a major portion of data value
Amazon Elasticache	Fast temporary storage for small amounts of data Highly volatile data
Amazon S3	BLOBs Static Websites

Posted By -	Karan Gupta

Posted On -	Wednesday, October 20, 2021

Updated On -	Sunday, December 25, 2022

Query/Feedback

Your Email Id

Subject

Query/Feedback	Characters remaining 250