Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When using Sendgrid as SMTP mailserver in QMC we get error message Failed sending email with the option Send test e-mail.
With NPrinting on the same server it works fine.
In the config files we changed
<!-- Set to true to enable secure SSL connection to SMTP server. -->
<add key="UseSSLForSMTP" value="false"/>
to true
Hello, Since we do not specifically know about/test Sendgrid with QlikView and it's configuration perhaps check if there is anything in the sendgrid configuration which could allow connections only from NPrinting right now, but also needs to allow from QlikView?
The QMC test mail button and the distribution service actually use different components in QlikView. So it can be that one works and one doesn't - and visa versa. You can also try to verify if it works (sends and email for a task distribution, or if this also fails) when trying to send
- Can you verify if QlikView will otherwise connect to a different SMTP service on port 587 e.g gmail or office365 for testing purposes? e.g some details about setting that up:
Since you mention the same settings work for NPrinting on the same server.
You can also test a standard telnet as per this article: https://docs.microsoft.com/en-us/exchange/mail-flow/test-smtp-with-telnet?view=exchserver-2019
- One further suggestion could be to test connecting to sendgrid with a more recent version of QlikView server than April 2019 as perhaps there are some differences in TLS/SSL ciphers/protocols used here for communication. Perhaps there could be a limitation here with the secure connections accepted by sendgrid coming from an older version of QlikView. That could also be partly why a newer version of NPrinting doesn't see issues using the same settings from the same server.
Hello,
Which versions of QlikView and NPrinting are you using on that server?
Which port do you specify for SMTP?
Which config file did you change as this is located in two places:
e.g as referenced on https://community.qlik.com/t5/Knowledge/QlikView-Test-mails-can-be-sent-successfully-but-task-mails/...
Change the QVManagementService.exe.config that is located at C:\Program Files\QlikView\Management Service. You will need to change <add key="UseSSLForSMTP" value="false"/> from false to true.
Have you checked if anything is registered on the SendGrid mailserver logs after the test email?
Do the QlikView QMS logs register any error at the time?
Hi Jon,
QlikView version April 2019 SR1
NPrinting November 2020 version 20.39.3.0
Port 587. It is the same for NPrinting and QlikView
Changed <add key="UseSSLForSMTP" value="false"/> from false to true.
and there are no errors in QMS logs at the time
Hi Jon,
There was nothing registered on the SendGrid mailserver logs after the test emai.
Hello, Since we do not specifically know about/test Sendgrid with QlikView and it's configuration perhaps check if there is anything in the sendgrid configuration which could allow connections only from NPrinting right now, but also needs to allow from QlikView?
The QMC test mail button and the distribution service actually use different components in QlikView. So it can be that one works and one doesn't - and visa versa. You can also try to verify if it works (sends and email for a task distribution, or if this also fails) when trying to send
- Can you verify if QlikView will otherwise connect to a different SMTP service on port 587 e.g gmail or office365 for testing purposes? e.g some details about setting that up:
Since you mention the same settings work for NPrinting on the same server.
You can also test a standard telnet as per this article: https://docs.microsoft.com/en-us/exchange/mail-flow/test-smtp-with-telnet?view=exchserver-2019
- One further suggestion could be to test connecting to sendgrid with a more recent version of QlikView server than April 2019 as perhaps there are some differences in TLS/SSL ciphers/protocols used here for communication. Perhaps there could be a limitation here with the secure connections accepted by sendgrid coming from an older version of QlikView. That could also be partly why a newer version of NPrinting doesn't see issues using the same settings from the same server.