Configuring Publisher to be able to make SSL connection to an SMTP email service

[Sonja_Bauernfeind]

Attempting to connect to Gmail SMTP server over port 587, Amazon SES over port 587 and Office Mail 365 over port 587 using SSL, results in a connection error.  This article explains what needs to be done in order to make this connection work properly.

Environment:

• QlikView all versions

Cause:

Email servers may require encryption when sending email.

Resolution:

Use the following steps to configure an SSL connection to an SMTP email service when using Publisher:

1. Browse to C:\Program Files\QlikView\Management Service and edit the QVManagementService.exe.config file.
2. Look for string "UseSSLForSMTP". If the entry already exists, edit its value to "true"
3. If "UseSSLForSMTP" does not exist, place the following two lines of code under the <!--****** SMTP ****** --> section:
   • <!--The following allows SSL connections to an SMTP mail service-->
   • <add key="UseSSLForSMTP" value="true"/>
4. Browse to C:\Program Files\QlikView\Distribution Service and edit the QVDistributionService.exe.config file.
5. Look for string "UseSSLForSMTP". If the entry already exists, edit its value to "true"
6. If "UseSSLForSMTP" does not exist, place the following two lines of code under the <!--****** SMTP ****** --> section:
   • <!--The following allows SSL connections to an SMTP mail service-->
   • <add key="UseSSLForSMTP" value="true"/>

For Gmail, use port 587(smtp.gmail.com);Also the Gmail account needs to:

• "2-Step Verification": Disabled;
• "Access for less secure apps": Enabled
• Change the above settings from https://www.google.com/settings/security

For Amazon Simple Email Service(SES), use port 587.

For Microsoft 365 service, use smtp.office365.com for address and port 587. Also see the following article for an alternative: Office 365 SMTP setup for Qlikview