At the time this knowledge base article written (Foglight 5.9.7), Foglight does not support connect Microsoft SQL server backend repository via SSL during the setup/install, However, here the workaround:
2. Install Foglight and use non secure/ssl connection to Microsoft SQL Server
3. Stop FMS
4. Get certificate authority (CA) certificate(s) from step 1
5. Import CA certificate(s) to Foglight Management Server’s JRE keystore
Linux:
$FGLHOME/jre/bin/keytool –keystore $FGLHOME/jre/lib/security/cacerts –storepass changeit -import -trustcacerts -alias dbroot -file dbroot.cer
Windows:
$FGLHOME\jre\bin\keytool –keystore $FGLHOME\jre\lib\security\cacerts -import -trustcacerts -alias dbroot -file dbroot.cer
6. Go to $FGLHOME/config/datasource directory and edit datasource-sqlsvr.properties file; Add db.encrypt = true at end of file something like this
#Driver extra connection properties, format:
# db.=
db.encrypt = true
7. Restart FMS and now you are connected to backend SQL server with encrypted connection
Note:
$FGLHOME is the directory location where you installed Foglight Management Server
Default location for Linux is: /home/<os username>/Quest/Foglight
Default location for Windows is: c:\Quest