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
- 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.
Click to Enlarge
How To Create An RDS?
Click to Enlarge
Click to Enlarge
Click to Enlarge
Click to Enlarge
Click to Enlarge
Click to Enlarge
Database Status
Click to Enlarge
Click to Enlarge
Database Configurations
- Endpoint
- "Publicly Accessible" should be set to "Yes".
Click to Enlarge
Click to Enlarge
Connect To The Database
Server: sample-database.criatfcnohqo.us-east-2.rds.amazonaws.com,1433
Username: admin
Password: <Created by you>
Click to Enlarge
Click to Enlarge