(SQL Server) Google Authenticator Algorithm

Example code implementing the Google Authenticator algorithm.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    -- This example assumes the Chilkat API to have been previously unlocked.
    -- See Global Unlock Sample for sample code.

    -- Generating TOTP Base32 Secret: 
    -- When you enable 2FA with a TOTP-based authenticator app, Google will provide you with a QR code
    -- that you can scan using the app. This QR code contains a TOTP base32 secret.
    -- You can also choose to view and copy the secret manually.

    DECLARE @secretBase32 nvarchar(4000)
    SELECT @secretBase32 = 'JBSWY3DPEHPK3PXP'

    -- Do the following to calculate the 6-digit decimal Google authenticator token for a base32 secret,
    -- given the current system date/time.
    DECLARE @crypt int
    -- Use "Chilkat_9_5_0.Crypt2" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.Crypt2', @crypt OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    DECLARE @otp nvarchar(4000)
    EXEC sp_OAMethod @crypt, 'Totp', @otp OUT, @secretBase32, 'base32', '0', '', 30, 6, -1, 'sha1'


    PRINT '6-digit decimal token = ' + @otp

    EXEC @hr = sp_OADestroy @crypt


END
GO