'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Microsoft 365 SMTP AUTH LOGIN Errors in QlikView
Question details
Users need to resolve an unexpected AUTH LOGIN response error when configuring QlikView to send emails via Microsoft 365 SMTP.
- Product
- QlikView and Microsoft 365
- Device & OS
- not provided
- Scenario
- Setting up automated email alerts and report distribution in QlikView using a Microsoft 365 Exchange mailbox.
- Observed behavior
- QlikView fails to connect to smtp.office365.com on port 587 and throws an unexpected AUTH LOGIN response error, preventing emails from being sent.
Ensure you have administrative access to the QlikView Management Console and the Microsoft 365 Admin Center to review security policies and SMTP configurations.
Verify QlikView SMTP Configurations and Microsoft 365 Mailbox Settings
Check that QlikView's mail server settings match Microsoft 365 requirements and confirm that authenticated SMTP is explicitly enabled for the sending account.
Microsoft 365 disables Basic Authentication (including SMTP AUTH) by default for security reasons. Legacy applications like QlikView that rely on this authentication method will fail to connect unless it is manually enabled for the specific mailbox.
It is highly recommended to use a dedicated service account for this integration and ensure that your organization's Azure Active Directory policies allow legacy authentication for that specific account.
In the QlikView Management Console (QMC), navigate to System > Setup > Mail Server. Set the SMTP server address to 'smtp.office365.com' and the port to 587.
Ensure that the STARTTLS (or TLS) encryption option is enabled. Enter the full email address of the Microsoft 365 account as the username, along with its correct password.
Log in to the Microsoft 365 Admin Center. Go to Active users, select the user account configured in QlikView, click on the 'Mail' tab, and select 'Manage email apps'. Ensure 'Authenticated SMTP' is checked and save the changes.
If the error persists, check your Azure Active Directory properties. If 'Security Defaults' are enabled, legacy authentication (SMTP AUTH) is blocked globally. You may need to transition to Conditional Access policies to allow SMTP AUTH for specific IPs or accounts.
Need a Lightweight Alternative to Microsoft Office? Try WPS Office
If complex Microsoft 365 configurations, tenant security policies, and recurring subscription fees are slowing down your daily workflow, consider switching to WPS Office. It provides a robust, offline-capable suite for handling your daily document needs seamlessly.
- 1. Visit the official website: Open your web browser and go to the official WPS Office website to access the free download page.
- 2. Download the software: Click the 'Free Download' button to get the installer for Windows, Mac, or Linux systems.
- 3. Install and get started: Run the installer, follow the simple on-screen instructions, and launch WPS Office to start working immediately.
Frequently Asked Questions
Why does Microsoft 365 block SMTP AUTH by default?
Microsoft 365 disables Basic Authentication (SMTP AUTH) by default to enhance tenant security and prevent automated brute-force attacks. You must explicitly enable it per-mailbox for legacy applications that require it.
Can I use port 25 instead of 587 for Microsoft 365 in QlikView?
Port 587 with STARTTLS encryption is the recommended and standard configuration for SMTP client submission in Microsoft 365. Port 25 is typically reserved for server-to-server mail routing and is often blocked by ISPs.
What if my organization mandates Multi-Factor Authentication (MFA)?
If MFA is strictly enforced across your Microsoft 365 tenant without exceptions, standard SMTP AUTH will fail. You will either need to generate an App Password (if allowed by your admin) or use a modern authentication approach such as Microsoft Graph API, which may require upgrading your QlikView setup.
