NEW FEATURE | Join Amazon RDS for SQL Server to Self Managed Active Directory | JULY 2023 RELEASE

Windows Authentication Options for Amazon RDS for SQL Server
Windows Authentication Options for Amazon RDS Custom for SQL Server
Management Instance & Amazon RDS SQL Server Port Requirements
Launch Management Instance and join to the self Managed Active Directory Domain and Install SQL Server Management Studio (SSMS)
Create Organizational Unit (OU) in Active Directory
Create a domain user with delegated permissions to perform domain join of RDS DB Instance
Create a domain user for SQL login
Create a encrypted secret in AWS Secrets Manager with domain join credentials
Join Amazon RDS to self Managed Active Directory
Test SQL login for domain user

Links:
Github: https://github.com/unmaskitnow/rds-sq...
Prerequisites setup video covered here:    • Install Active Directory on Amazon EC...  
Working with Self Managed Active Directory with an Amazon RDS for SQL Server DB instance: https://docs.aws.amazon.com/AmazonRDS...

Chapters:

00:00 Intro
04:08 Architecture
04:39 Security Group Rules
06:11 Demo
08:19 MGMT Domain Join
12:11 Create OU
13:45 Create domain user for RDS domain join
14:52 Delegate control on OU for domain user
16:05 Create KMS key
17:57 Create Secret
20:34 RDS Domain Join
28:31 Install SSMS
33:58 Connect to RDS from SSMS
35:11 Create AD user for SQL login
37:10 Test Windows Authentication for SQL login
40:26 DB query to check auth_scheme