KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: Setting up 4D's SQL Server to use SSL protocol
PRODUCT: 4D SQL | VERSION: 11.3 | PLATFORM: Mac & Win
Published On: January 21, 2009

If you want 4D's SQL Server to use the SSL protocol for processing connections you must follow these two steps:

  1. Check the Enable SSL option in the application preferences (SQL, Configuration page) as shown here:



  2. Copy the key.pem and cert.pem files into the following location: MyDatabase/Preferences/SQL (where "MyDatabase" represents the database folder/package).

You can use OpenSSL to generate "self-signed" certificates for testing.

Commented by John Milton on December 15, 2010 at 7:19 AM
On the other end, if you are using 4Ds SQL Login command to connect to the SSL enabled SQL server, you'll need to specify that you want to use ssl by adding ":ssl" suffix to the IP:ip:port parameter, which isn't mentioned in the SQL Login docs at the time of writing eg

SQL Login("IP:192.168.x.y:19812:ssl";"username";"pass";*)