SSRS email basic authentication replacement

Question

SSRS email basic authentication replacement

Michael Morris 6

Hi,

For sending emails from our SSRS environment we currently use basic authentication to connect SSRS to our Office 365 environment, with this being deprecated in the coming months does anyone have the new settings that will be needed to allow us to still email reports out to our clients.

Thanks,

Mike

Chambers, Bart 1 Reputation point

2022-08-16T19:27:54.507+00:00

Have the same question. Here's what he's referencing for the depreciation of basic authentication.

Anyone figure out a work around for this one yet?

Thanks
Michael Morris 6 Reputation points

2022-09-17T08:30:41.073+00:00

I am currently looking at the option of SMTP Auth which will remain in place once basic auth.

authenticated-client-smtp-submission
Brady Riopelle 1 Reputation point

2022-10-18T18:58:19.173+00:00

Hey MichaelMorris,

Just curious if you brought this up to Microsoft yet to find out what the best approach will be once basic auth is deprecated? (believe you got until end of the year now to re-enable basic auth)

But curious if they are going to be releaseing SQL/SSRS service packs for SSRS emailing.
Hackett, Rob 0 Reputation points

2024-10-16T21:08:01.6033333+00:00

Wondering if anyone has heard anything from Microsoft about this? I can't seem to find anything else on this topic and no mention of alternatives, or support for this in future versions of SSRS.
Elaine Markley 0 Reputation points

2025-01-05T15:43:59.3466667+00:00

Did you get anywhere with this? Is there a repkacement or solution to working with 365 snd sending emails

2 answers

Your answer

Chambers, Bart 1 Reputation point

2022-08-16T19:27:54.507+00:00

Have the same question. Here's what he's referencing for the depreciation of basic authentication.

Anyone figure out a work around for this one yet?

Thanks
Michael Morris 6 Reputation points

2022-09-17T08:30:41.073+00:00

I am currently looking at the option of SMTP Auth which will remain in place once basic auth.

authenticated-client-smtp-submission
Brady Riopelle 1 Reputation point

2022-10-18T18:58:19.173+00:00

Hey MichaelMorris,

Just curious if you brought this up to Microsoft yet to find out what the best approach will be once basic auth is deprecated? (believe you got until end of the year now to re-enable basic auth)

But curious if they are going to be releaseing SQL/SSRS service packs for SSRS emailing.
Hackett, Rob 0 Reputation points

2024-10-16T21:08:01.6033333+00:00

Wondering if anyone has heard anything from Microsoft about this? I can't seem to find anything else on this topic and no mention of alternatives, or support for this in future versions of SSRS.
Elaine Markley 0 Reputation points

2025-01-05T15:43:59.3466667+00:00

Did you get anywhere with this? Is there a repkacement or solution to working with 365 snd sending emails

Answer 1

Hi @Michael Morris ,

with this being deprecated in the coming months

What do you mean by deprecated? I'm not familiar with how to connect SSRS to an Office 365 environment.
For inquiries about connecting to Office 365 products, please add the relevant tags for assistance.
Best Regards，
Joy

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

ZoeHui-MSFT 41,491

Hi @Michael Morris ，

Do you mean the SSRS ability to connect to Office 365 SMTP will be removed in a few months?

I didn't find any news about this, but if its updated version removes the feature, I think you can use the previous version to maintain this Function.

If I misunderstand your issue, please incorrect me.

Regards，

Zoe

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Michael Morris 6 Reputation points

2022-07-24T11:15:28.487+00:00

Hi @ZoeHui-MSFT ,

Thanks for your response, what I mean is that as SSRS uses basic authentication currently, this is meant to be disabled this year, though I believe you can leave it on if you wish to. I will not have control over the decision so there is a good chance I will not be able to this as a workaround. Do you know what the roadmap will be for the change to OAuth? Just attempting to pre-empt this before the change prevents connections completely and we can no longer send emails from our SSRS server.

Thanks,

Mike
Joyzhao-MSFT 15,631 Reputation points

2022-08-02T09:43:50.57+00:00

Hi,

Do you know what the roadmap will be for the change to OAuth?

Has your issue been resolved?
As I said before, you need to add relevant tags to help you resolve this issue better.
Regards,
Joy

Share via

SSRS email basic authentication replacement

2 answers

Your answer