Forum Discussion
SQL-Server - traffic encryption can't connect using only hostname
I have setup a certificate in SQL server configuration manager and can make encrypted connections fine using the FQDN of the server but not if I just use the hostname. I have other servers whe...
This error:
> SSL Provider, error: 0 - The target principal name is incorrect.
indicates that a Kerberos Service Principal Name does not exist for the name used by the client when connecting to the server. Look in the SQL Server Error Log shortly after startup for messages mentioning Kerberos Service Principal Names (or SPN as they are somtimes known).
Take a look at an article I wrote about configuring SPNs at https://www.sqlserverscience.com/configuration/enable-kerberos-authentication-without-rebooting-sql-server/