Can't get SendGrid to work with SSRS 2012 and SMTP

Scott Klein 161 Reputation points
2024-03-29T21:04:51.5466667+00:00

I have been doing a lot of online searching to find an answer, but I can't find anything substantial. I am trying to configure SSRS 2012 to use SMTP with SendGrid. All that I am finding says that I need to go into Reporting Services Configuration Manager, and set the Authentication to Basic, then enter the api key and password. Well, I don't have that option in Email Settings the configuration manager.

User's image

So I am trying to configure it via the config, as shown below:

User's image

However, the error we are getting is: Failure Sending Email: Mailbox unavailable. The server response was: Unauthenticated senders not allowed.

What am I missing?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,065 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 41,496 Reputation points
    2024-04-01T02:54:49.2766667+00:00

    Hi @Scott Klein,

    From the docu at https://sendgrid.com/docs/for-developers/sending-email/smtp-errors-and-troubleshooting/#550-unauthenticated-senders-not-allowed

    If you’re getting an “Unauthenticated Senders Not Allowed” error, the problem usually lies in authenticating with our SMTP server. This error gets triggered when there was an attempt to hand over an email message through smtp.sendgrid.net before authenticating the connection with your SendGrid username and API key.

    To fix this issue, you’ll want to make sure that you’ve configured your setup to connect to smtp.sendgrid.net using authentication, and that the credentials you’re using are your SendGrid username and a properly configured API key as the password. For more on API keys, see [API Keys](https://docs.sendgrid.com/ui/account-and-settings/api-keys/"API Keys").

    If you’re using cPanel/Exim, you’ll want to make sure it’s configured to authenticate every time it connects to smtp.sendgrid.net.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.