Tell me more ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.
up vote 1 down vote favorite

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!

share|improve this question
are you using the public DNS name of the server? – Bozojoe Jan 30 at 2:32

1 Answer

up vote 1 down vote

Add this parameter for the connection string: TrustServerCertificate=true

Solved in my case.

share|improve this answer
You'll be negating the use of a public cert if you do that: you're basically telling the SQL server client to ignore the server cert altogether. – Stephane Feb 12 at 12:59

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.