SQL Server :- “Provider: SSL Provider, error: 0 – The target principal name is incorrect”


Playing around with SSL Certs on SQL Server and ran into a nice well informed error.


Error Message




Cannot connect to DB01.


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.) (.Net SqlClient Data Provider)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=-2146893022&LinkId=20476

Server Name: DB01
Error Number: -2146893022
Severity: 20
State: 0




SQL Server Management Studio ( SSMS )


  1. Access the “Connection Properties” tab
    • Determine whether you really want to Encrypt Connection
      • Based on that determination, please check or uncheck “Encrypt” connection
  2. Access the “Additional Connection Parameters” tab
    • In the “Enter additional connection string parameters” group box
      • Enter “TrustServerCertificate=Yes

Screen Shot

Screen Shot – Tab – Connection Properties

Screen Shot – Tab – Additional Connection Parameters


SQL Server Configuration Manager


  1. Launch SQL Server Configuration Manager
  2. Access each bitness specific configuration
    • SQL Native Client [version] Configuration (32bit)
    • SQL Native Client [version] Configuration
  3. Right click on the configuration node
  4. From the drop down menu, please select Properties
  5. The Flags window appears
    • Set “Trust Server Certificate” to YES

Screen Shot

SQL Native Client [version] Configuration (32it) // SQL Native Client [version] Configuration




As always there is a lot more to it.

So please choose one of these two:

  1. Kenny Chesney Kid Rock- Luckenback, Texas
    Got us feuding like the Hatfields and McCoys
    This successful life we’re living’s

    Out in Luckenbach, Texas, ain’t nobody feeling no pain
    Ain’t nobody feeling no pain
    The way we are doing it at 4 in the morning
    In Detroit Michigan
  2. Ghetto Boys – My Mind is playing tricks on me
    I feel like I am the one doing coke …
    Now she is back with her mother
    This year Halloween fell on a weekend
    Me and Geto Boys are trick-or-treating


Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s