Post reply

Force SQL Service to start in NTLM Authentication

  • April 4, 2014 at 6:16 am

    #306060

    In order to reproduce an error, I need to for the SQL Server to start in NTLM authentication instead of Kerbros. Is there a way to do the same?

    ---------------------------------------------------
    Thanks,
    Satheesh.

  • April 4, 2014 at 6:40 am

    #1703270

    If I am not mistaken Kerberos authentication works off the SPN that the SQL Server service creates in the AD domain, or that is created manually. If the SPN is not found when authenticating a login it switches to NTLM. You would need to ensure the SPN is not found or does not exist. The service account for SQL Server would need to be blocked from creating an SPN if it is not already (if the SPN was created manually).

    More information can be found here on the Kerberos and NTLM.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply