If you need a relational database in AWS, then the Relational Database Service (RDS) is the way to create one. RDS offers support for six different database engines, with Microsoft SQL Server being one of them (and it’s the focus of this video).
In this video, I’ll provide a short overview of RDS and why you would use it. Then in a hands-on tutorial, I’ll walk through how to create a new RDS database, with Microsoft SQL Server as the engine. Then we’ll see how to connect to it from SQL Server Management Studio (SSMS), and troubleshoot some common connection errors along the way.
Link to documentation referenced:
• Scenarios for accessing a DB instance in a VPC: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_VPC.Scenarios.html
??If you’re interested in getting AWS certifications, check out these full courses. They include lots of hands-on demos, quizzes and full practice exams. Use FRIENDS10 for a 10% discount!
– AWS Certified Cloud Practitioner: https://academy.zerotomastery.io/a/aff_n20ghyn4/external?affcode=441520_lm7gzk-d
– AWS Certified Solutions Architect Associate: https://academy.zerotomastery.io/a/aff_464yrtnn/external?affcode=441520_lm7gzk-d
If you want to learn about NON-relational databases in AWS, check out this video about DynamoDB: https://youtu.be/FQrN5aJWa_U
00:00 – Overviewing the Relational Database Service (RDS) in AWS
01:33 – Creating an RDS database in AWS with Microsoft SQL Server as the engine
03:36 – Introducing SQL Server Management Studio (SSMS) for connecting to RDS SQL Server
04:49 – Connecting to an RDS SQL Server database from SSMS
06:21 – ERROR! Cannot connect to database from SSMS, and how to fix it
08:16 – Updating VPC security groups to connect from SSMS from outside the VPC
10:05 – Additional documentation and examples for connecting to SQL Server
10:35 – Navigating SSMS for a SQL Server database
11:46 – Deleting the RDS SQL Server database
