14,494 questions
Have you tried to click "This server required a secure connection (SSL)" ?
SQL Database Mail configuration with sendgrid
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 87%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
AJEET SINGH
1
Reputation point
I have been trying to setup sendgrid on SQL Database Mail but all the time it says Cannot send mail to mail server.
This is what i have done.
I have sendgrid accound with ******@mydomain.com and created api key and SG.xxxx password.
As this is prod setup instance, i had done domain level authentication and my webmaster updated CNAME as requested by sendgrid.
Tested using TELNET smtp.sendgrid.net 587 and authenticated with SG.xxxx password Base64 encoded and this was able to send email from ******@mydomain.com to ******@mydomain.com
I setup profile with @mydomoain.com as SQL notification Profile and selected Basic Authentication and provided 'apikey' as username and 'SG.xxx' as password in Database Mail - 'Configure Database Mail' option in SQL SSMS. Unchecked - 'The server requires secure authentication (SSL) connection' Port 587
I tried to 'Send Test Mail' with 'abc@keyman .com' to '@mydomain.com' but the Database Mail reflects as below screenshot error
I have tried using ******@mydomain.com and sendgrid account password in Database Mail Config wizard for Basic authentication, but sendgrid suggested they don't accept Basic authentication. Please help how and where should i pass the api key if not under Basic Authentication ?
I tried updating with msdb.dbo.sysmail_add_account_sp nad updating records but it too didn't resolve and send email from Database mail.
Any help/ guidance would be greatly appreciated or if you had faced this how have you resolved it.
SQL Server Other
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Seeya Xi-MSFT 16,586 Reputation points2021-10-01T06:38:10.947+00:00 Hi @AJEET SINGH ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Seeya -
AJEET SINGH 1 Reputation point
2021-10-01T10:06:30.063+00:00 Hi Seeya,
The resolution provided didn't helped.Regards
Sign in to comment
3 answers
Sort by: Most helpful
-
Stratos Matzouranis 36 Reputation points2021-09-27T11:56:26.867+00:00 -
AJEET SINGH 1 Reputation point
2021-09-27T21:39:48.247+00:00 Yes, i tried both with/without ssl.
An additional information that's missing above:
Under Basic authentication I am using username as base64 encode of string "apikey" and password also base64 encoded of "SG.xxx"
I encoded this using below on linux terminal opensslecho -n '<YOUR_API_KEY>' | openssl base64
Will this affect anything on Database Mail configuration ?
Should i use some other base64 encode method. Although, by using cmd - telnet with this encoded key I was able to authentication and send email.
Sign in to comment -
-
Seeya Xi-MSFT 16,586 Reputation points
2021-09-28T06:39:37.77+00:00 Hi @AJEET SINGH ,
Could you refer to this troubleshooting first: https://houseofbrick.com/troubleshooting-database-mail-for-sql-server/
Maybe it is hopeful for you.
If it doesn't work please feel free to let me know.Best regards,
Seeya
If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
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. -
Ben Miller (DBAduck) 966 Reputation points2021-10-01T12:06:15.127+00:00 Have you checked https://www.mssqltips.com/sqlservertip/4507/sql-server-database-mail-configured-with-the-send-grid-email-service-in-the-azure-market-place/
This is how you can configure it.