Hi Reddy
I have not configured this, but believe this is a setting in the CM Sql Server ODBC connection settings.
If you go to the connection settings you should can set additional information in the ServerName string used . If you select the help at this point it will give you details on the connection including the servername entry formats such as
   [<Protocol>:]<ServerName>[.<Port Number>]     [<Protocol>:]<ServerName>\<InstanceName>[.<Port Number>]  
I hope this helps

This is the screen that I get; how to enable it and what values should be given.

I tried in my test env, I don't have SSL but it's still selected.  Still, it's working. How come 

This is the screen that I get; how to enable it and what values should be given.

I tried in my test env, I don't have SSL but it's still selected.  Still, it's working. How come 

Hi Reddy,

These values line up with the normal ODBC connection string properties

https://learn.microsoft.com/en-us/sql/connect/odbc/connection-troubleshooting?view=sql-server-ver16

Trusted Server Certificate (if enabled) will look to SKIP server certificate validation

Host Name in Certificate looks to line up with the HostNameInCertificate keyword which can be used to specify the name expected from the server certificate if you get an error.

I would expect, if your SQL server has a certificate that is VALID from your CM servers perspective, you should just be able to tick 'Encrypt' and leave the 'trusted' and 'host name' as blank / unchecked

-Scotty