The Amazon VGT2 team has been actively working on new features at an impressive rate. They have introduced a variety of data protection and security enhancements, making their service an ideal choice for enterprise applications.
Today, we are pleased to announce the addition of SSL support for RDS for SQL Server.
With this enhancement, you can now secure your data both during transmission and when stored:
- Activate SQL Server SSL to safeguard data as it moves between your application server and your RDS database instance.
- Utilize SQL Server’s column-level encryption to secure data at rest.
- Deploy your RDS database instance running SQL Server within a Virtual Private Cloud to ensure network isolation.
Enabling SSL Support
To enable SSL Support, follow these simple steps:
- Download a public certificate key from RDS.
- Use the Microsoft Management Console (MMC) to import the certificate into Windows.
Making SSL Connections
You can establish an SSL connection to your RDB database instance running SQL Server in several ways. Here are two popular methods:
- If you are connecting programmatically to RDS, include “encrypt=true” in your connection string. For instance:
Server=##.##.##.##;Database=dbname;uid=username;pwd=password;encrypt=true - When using SQL Server Management Studio, ensure to select the “Encrypt connection” option.
Your Opinion Matters
I believe that the combination of these three features makes RDS for SQL Server extremely suitable for almost any enterprise. What are your thoughts?
For more insights, check out this additional blog post that delves deeper into the topic.
Additionally, for authoritative information, visit this resource that discusses SSL connections comprehensively. If you’re seeking community support, this Reddit thread offers valuable user experiences and advice.
— Lisa
P.S. You can also establish SSL connections to an RDS database instance running MySQL.
Leave a Reply