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

Background

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

 

Error Message

Image

Textual


===================================

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

 

Remediation

Client

SQL Server Management Studio ( SSMS )

Outline

  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

Outline

  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

Flags

 

Listening

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
    Link
  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
    Link

 

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 )

w

Connecting to %s