Sample code for 30+ languages & platforms
SQL Server Requires Chilkat v11.0.0+

Outlook.com SMTP: Replace Password Login with OAuth2

See more SMTP Examples

This replacement for the older password-login sample tests OAuth2 authentication without sending a message. The historical filename is retained for existing links. Setting OAuth2AccessToken makes Chilkat use XOAUTH2; leave SmtpPassword empty. No session log or token is printed.

Personal Outlook.com: This includes Microsoft-hosted Outlook.com, Hotmail, and Live mailboxes. Use delegated OAuth2; ordinary passwords and app passwords are not a replacement for Modern Authentication. SMTP uses smtp-mail.outlook.com:587 with STARTTLS; incoming IMAP/POP use outlook.office365.com on ports 993/995 with implicit TLS. Enable POP or IMAP under Settings > Mail > Forwarding and IMAP before using that protocol. See current Outlook.com settings.

First authorize the account with https://outlook.office.com/SMTP.Send and offline_access, then refresh the access token when needed. This example reads qa_data/tokens/hotmail.json from a private working directory. Microsoft Graph permissions such as Mail.Send or Mail.Read do not authorize these mail protocols. Do not print tokens or authentication logs.

Microsoft reference documentation

Chilkat SQL Server Downloads

SQL Server
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @iTmp0 int
    DECLARE @iTmp1 int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    --  Assumes Chilkat is unlocked. See Global Unlock Sample.

    DECLARE @token int
    EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @token OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OAMethod @token, 'LoadFile', @success OUT, 'qa_data/tokens/hotmail.json'
    IF @success <> 1
      BEGIN

        PRINT 'Could not read qa_data/tokens/hotmail.json from the private working directory.'
        EXEC @hr = sp_OADestroy @token
        RETURN
      END
    EXEC sp_OAMethod @token, 'JsonTypeOf', @iTmp0 OUT, 'access_token'
    EXEC sp_OAMethod @token, 'StringOfEquals', @iTmp1 OUT, 'access_token', '', 1
    IF (@iTmp0 <> 1) or (@iTmp1 = 1)
      BEGIN

        PRINT 'An OAuth access token is required. Authorize or refresh the account first.'
        EXEC @hr = sp_OADestroy @token
        RETURN
      END
    DECLARE @mailbox nvarchar(4000)
    SELECT @mailbox = 'user@example.com'
    DECLARE @mailman int
    EXEC @hr = sp_OACreate 'Chilkat.MailMan', @mailman OUT

    EXEC sp_OASetProperty @mailman, 'SmtpHost', 'smtp-mail.outlook.com'
    EXEC sp_OASetProperty @mailman, 'SmtpPort', 587
    EXEC sp_OASetProperty @mailman, 'SmtpSsl', 0
    EXEC sp_OASetProperty @mailman, 'StartTLS', 1
    EXEC sp_OASetProperty @mailman, 'RequireSslCertVerify', 1
    --  Microsoft SMTP submission uses STARTTLS on port 587, not implicit TLS on 465.
    EXEC sp_OASetProperty @mailman, 'SmtpUsername', @mailbox
    EXEC sp_OASetProperty @mailman, 'SmtpPassword', ''
    EXEC sp_OAMethod @token, 'StringOf', @sTmp0 OUT, 'access_token'
    EXEC sp_OASetProperty @mailman, 'OAuth2AccessToken', @sTmp0

    EXEC sp_OAMethod @mailman, 'SmtpConnect', @success OUT
    IF @success <> 1
      BEGIN

        PRINT 'Could not establish the SMTP STARTTLS connection.'
        EXEC @hr = sp_OADestroy @token
        EXEC @hr = sp_OADestroy @mailman
        RETURN
      END
    EXEC sp_OAMethod @mailman, 'SmtpAuthenticate', @success OUT
    EXEC sp_OAMethod @mailman, 'CloseSmtpConnection', @success OUT
    IF @success <> 1
      BEGIN

        PRINT 'SMTP authentication failed. Check token expiry, scope, mailbox, and account settings.'
        EXEC @hr = sp_OADestroy @token
        EXEC @hr = sp_OADestroy @mailman
        RETURN
      END

    PRINT 'SMTP OAuth2 authentication succeeded; no message was sent.'

    EXEC @hr = sp_OADestroy @token
    EXEC @hr = sp_OADestroy @mailman


END
GO