In this video, we'll look at how to connect Teleport to Microsoft SQL Server with Active Directory authentication. We'll also be exploring Teleport's RBAC system, Audit logs, as well as how to connect a GUI like Azure Data Studio, SSMS, or Datagrip to our database via Teleport.

Some of the mentioned resources may already be set up or active in your environment. If so, feel free to utilize the timestamps below to maximize your situation.

Timestamps:

0:00 - Intro

0:40 - Architectural Diagram
Prerequisites

2:40 - Create AWS Managed AD

4:13 - Create RDS Sql Server Instance

5:57 - Create Windows EC2 for AD Management

8:18 - Configuring Windows EC2 Instance and Adding New User
Teleport

12:00 - Set Up EC2 for Teleport Database Service

13:23 - Configuring EC2 for Teleport Database Service

19:00 - Starting Teleport Database Service

25:00 - Install mssql-cli and Create User Login for Microsoft SQL

27:46 - Connecting to SQL Server Instance with Teleport

29:18 - Teleport RBAC Demonstration

32:07 - Connecting to SQL Server with a GUI (Azure Data Studio, etc)

35:11 - Teleport Audit Log

36:01 - Outro