Email Tool - Login Denied Error

[jsumms]

Hello,

I am using the Email tool using an SMTP Connection via the "Use Data Connection Manager (DCM)" option. I am connecting using a Credential of the "OAuth with Alteryx Application"

The Workflow will successfully run and send e-mails if I run the Workflow from my home office being connected via VPN. However, when I try to run the Workflow while being in our corporate office and connected directly to the network it gives us "Error: Email (1): Record#1: Func 'curl_easy_perform' failed, ret = 67, desc = Login denied" error.

We are not changing any parameters related to the SMTP Connection and I have been working with my IT team but we cannot figure out what may be causing the Login Denied issue when at the corporate office. Anyone have any ideas as to what the fix may be for this? We also have run a test using Windows Powershell using my login credentials and the same SMTP and it will send a test e-mail when we do it it through there.

[jsumms]

Thanks for following up. This is what I am using currently

[jonathan_hornbeck]

I'm having the same issue after upgrading to 2023.1. Since I upgraded our server to 2023.1 as well, I don't want to have to downgrade everything. Is there anything that has fixed this? I tried a new app password and that didn't work either. Here's my set up which is working fine for server notifications.

[renat_isch]

Hi @jsumms, I was able to reproduce the error you've encountered while setting up a connection with configuration you provided. We'll attempt to investigate more, but based on the screenshot you provided you're using basic, username/password, authentication when setting up a connection. Microsoft is deprecating support for basic SMPT authentication, https://learn.microsoft.com/en-us/exchange/clients-and-mobile-in-exchange-online/deprecation-of-basi... therefore it is recommended that you use OAuth-based authentication when accessing your ExchangeOnline account. To do this, please active DCM and configure the following connection: 

Using the above configuration shall address the issue. 

[elliottwood]

The link you have provided leads to a dead 404 page. After looking up what was probably supposed to be in the link, Microsoft site it says they ended basic support in 2022. So why is this now effecting us half way through the year in 2023? Older versions of Alteryx work exactly as they are supposed to. Why would this be Microsofts fault? Especially seeing as Basic SMTP is supported by your previous version, and Microsoft has no issues letting it run? 

[jsumms]

@renat_isch we have also tried to use the DCM connection method in the past using a Data Source with the SMTP Server and Credential of the OAuth w Alteryx App option and it gives us the same results as using the basic username/password method. The DCM method is actually what we were initially using prior to setting it up through a Virtual Server Environment.

[renat_isch]

Hi @jsumms/ @elliottwood , thanks for your inputs. I was able to replicate that error with basic authentication, whereas Azure AD-based authentication is working just fine for me. Could you please submit support tickets to Alteryx support team - they will collect additional detail we might need to resolve this error.. In the meantime, we will attempt to find the root cause of the behaviour you're facing with basic authentication. 

[jsumms]

@renat_ish thanks I have a support ticket submitted and am working through this with them at the moment. Hopefully we can get a resolution. At the moment they are thinking it may have something to do with the AMP Engine in the 2023.1 version, but they are currently looking into it further.

[Dboff]

Hi Renat,

I have changed my configuration to match as per your screenshot but I am still getting the same error. I have 3 emails to be sent, and the error is only showing on the 1st one.

Could you please advise what would be my next steps to fix this?

Thank you,

Daiana

[renat_isch]

Hi @Dboff, we're aware of the issue and were able to identify the root cause. The problem only persists when using basic username/password authentication. One of our upcoming patch releases will introduce the fix to the issue. I will provide further updates early next week. 

[Hamder83]

 I had the same issue, and I sat op a connection over https://sendgrid.com/ in stead. This works as a charm :)

So now I can send from alteryx, using our email. With sendgrid as smtp :)