Sample Header Ad - 728x90

SQL Server - Error with Database Mail when recipient email has non-ASCII characters

0 votes
0 answers
90 views
I'm getting an error when trying to send an e-mail through DbMail, apparently because the recipient has an accent on the e-mail. Is there anything inside SQL Server that can fix this (or that a DBA can do)? This is the error message I'm getting through 'sysmail_event_log' The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2024-11-01T18:41:43). Exception Message: 1) Exception Information =================== Exception Type: Microsoft.SqlServer.Management.SqlIMail.MailFramework.Exceptions.BaseMailFrameworkException Message: Cannot send mails to mail server. (The client or server is only configured for E-mail addresses with ASCII local-parts: someMailNáme@gmail.com) I tried checking the database mail settings but there is nothing more than just the basic settings there, like the address, server and login info. Edit: Checked with the team in charge of e-mail in the company and there was nothing they could change from our side. Also found this StackOverflow post with a similar issue that basicallly answer my question, SendGrid has no support for non-ASCII characters in the local-part of the email. This issue was open in 2018 and to this day there is still no fix for this case. https://stackoverflow.com/questions/48270879/send-internationalized-email
Asked by SergioL (11 rep)
Nov 1, 2024, 10:53 PM
Last activity: Nov 8, 2024, 02:34 AM