Hi All,
if anyone has implemented the SSL Communication between the Content Manager 23.4 & MS SQL Server, can you share the steps or link? I was unable to find any info regarding that.
Cybersecurity
DevOps Cloud
IT Operations Cloud
If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it! Learn more
Hi All,
if anyone has implemented the SSL Communication between the Content Manager 23.4 & MS SQL Server, can you share the steps or link? I was unable to find any info regarding that.
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
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
Hi Scott,
Thanks for the quick reply, let me configure the SSL and get back to you.
can confirm this works