Press "Enter" to skip to content

Finding NTLM Connections to SQL Server

Andreas Wolter shares advice and a script:

In short: I recommend finding out now which connections to your SQL Servers still use NTLM, and fixing them before Windows disables NTLM by default. Most of them fall back to NTLM silently, because of a missing SPN, a connection by IP address or an alias. SQL Server itself has no setting for this – the work is in Active Directory, DNS and client connection strings.

Click through for several reasons why users might be connecting via the old and deprecated protocol, and what to do about it.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.