I have tried to connect to Microsoft SQL Server in SSL mode from ODBC Driver for SQLServer 18 version.
For that, I have created self-service and rootCA certificates and deployed them in both SQL Server and client machines. When trying to connect, getting the error -
[Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: The target principal name is incorrect.
[Microsoft][ODBC Driver 18 for SQL Server]Client unable to establish a connection
Can suggest what went wrong and how could I fix this issue?
Please point us to any references on how to create SSL certificates.