Integrate AWS SQL Server RDS with multiple AD
The scenario:
- I have a SQL Server RDS in us-east.
- I’m using a Managed Microsoft AD.
- I have an On-Prem datacentre too.
As we all know that we can easily integrate the Managed Microsoft AD with SQL Server RDS. But I need to grant my On-Prem AD users to access the RDS with Windows authentication.
Pre-Requirements:
- Managed Microsoft AD Enterprise.
- SQL Server RDS and attached to the Managed AD.
- Create a VPN connection between the VPC where the Managed AD is located and your On-Prem network.
Make sure your VPN is working fine. Now your Managed AD users can able to login to the SQL Server. For integrating your On-Prem AD user, we need to create the Trust relationship between the Managed AD and On-Prem AD.