This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(32, 8%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello Team, I previously encountered an issue with sending emails from SQL Server where I received an authentication error due to basic authentication being disabled. The team suggested implementing OAuth 2.0, but I struggled to find proper articles or video references for this implementation. Can anyone please help with guidance on how to implement OAuth 2.0 for SQL Server Management Studio (SSMS)?
I don't know much about OAuth, so I cannot help there, but I like to point out that you don't want to enable it for SSMS. SSMS does not send any mail. SSMS is just a tool to permit you connect to SQL Server run queries and perform management tasks through a UI experience.
And in this case, it is not really even an SQL Server issue. SQL Server just uses the OS to send mail, so this is more of an OS configuration issue. That is, you would get the same authentication error, if you tried to use a free-standing program to send mail over SMTP.
![](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(128, 52%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Hi Avinash,
The Open Specifications tags are designed for questions regarding the Open Specifications documentation (https://learn.microsoft.com/en-us/openspecs/protocols/ms-protocolslp/9a3ae8a2-02e5-4d05-874a-b3551405d8f9). As it doesn't appear that your question relates to one of these documents, I'll remove the tag.
Regards,
Kristian
Microsoft Open Specifications
![](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(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
@Avinash
Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
![](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, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
SQLServers database email does not support oauth only basic. Here are some options
Hi @Avinash
Refer to this doc for detail steps: Authenticate an IMAP, POP or SMTP connection using OAuth.
Best regards,
Cosmog
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".