Ssl – AWS RDS (SQL Server): SSL Connection – The target principal name is incorrect

amazon-rdssql-server-2012ssl

I have a Amazon Web Services (AWS) Relational Database Service (RDS) instance running SQL Server 2012 Express.

I've installed Amazon's aws.amazon.com/rds certificate in the client machine's Trusted Root Certification Authorities store.

However, when I connect to the RDS instance (using SQL Server Management Studio 2012) and check off "Encrypt Connection", I get the following error:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 – The target principal name is incorrect.) (Microsoft SQL Server)

What does this mean, and how can I fix it? Thanks!

Best Answer

Add this parameter for the connection string: TrustServerCertificate=true

Solved in my case.

Related Topic