SQL connections to Remote Desktop Server

[JoeRainero]

Hello,

We have a 2016 SQL server vm and a 2016 Remote Desktop Server Session Host vm running in Azure.  Are the connections from the RDS to the SQL encrypted ?  How can we know?

Thanks,

Joe

[rachelgomez_123]

Steps to Connect to Microsoft SQL Server remotely-

Step 1: Enabling TCP/IP protocol.
Step 2: Configure the Windows Firewall.
Step 3: Establishing the newly created rule.
Step 4: Connection to Server.

Regards,

Rachel Gomez

[JanoschUlmer]

Check https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-encrypted-connections-to-the-database-engine?view=sql-server-ver15#to-configure-the-server-to-force-encrypted-connections 

If the RDS VM and the SQL server VM is in Azure, why do you want to encrypt the traffic flowing via your own vnet?

[JoeRainero]

Hello,

As part of a SAR Questionnaire, we are being asked this question "Is End2End encryption in place for data in-transit using TLS 1.2 at miniminal?"  I believe this is needed to prevent a man in the middle attack.  

Thanks,

Joe