HTTP Negotiate/ Kerberos Authentication

To use Kerberos HTTP authentication, simply set the Login, Password, LoginDomain, and NegotiateAuth properties prior to calling any HTTP method (such as Download, QuickGetStr, SynchronousRequest, etc.)

Download Chilkat HTTP ActiveX

CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @http int
    EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    DECLARE @success int

    --  Any string unlocks the component for the 1st 30-days.
    EXEC sp_OAMethod @http, 'UnlockComponent', @success OUT, 'Anything for 30-day trial'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        RETURN
      END

    --  Set the login/password for HTTP NTLM Authentication:
    EXEC sp_OASetProperty @http, 'Login', 'myLogin'
    EXEC sp_OASetProperty @http, 'Password', 'myPassword'
    EXEC sp_OASetProperty @http, 'LoginDomain', 'myLoginDomain'
    --  Negotiate authentication allows the HTTP client
    --  to dynamically select either Kerberos or NTLM, depending
    --  on what the server supports.
    EXEC sp_OASetProperty @http, 'NegotiateAuth', 1

    --  Download a .zip from chilkatsoft.com:
    --  PS> This download URL doesn't actually require
    --  authentication.  You'll want to replace this URL with your own.
    EXEC sp_OAMethod @http, 'Download', @success OUT, 'http://www.chilkatsoft.com/preRelease/ChilkatDotNet2.zip', 'ChilkatDotNet2.zip'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
      END
    ELSE
      BEGIN
        PRINT 'Download Complete!'
      END
END
GO