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.