Kerberos

Test-DbaConnectionAuthScheme

Chrissy LeMaire (@cl), netnerds.net

Test-DbaConnectionAuthScheme View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Tests and reports authentication scheme and transport protocol details for SQL Server connections Description This command queries sys.dm_exec_connections to retrieve authentication and transport details for your current SQL Server session. By default, it returns key connection properties including ServerName, Transport protocol, and AuthScheme (Kerberos or NTLM). This is particularly valuable for troubleshooting authentication issues when you expect Kerberos but are getting NTLM instead.

New Release - Schwifty - All About SPNs

Drew Furgiuele

These commands were updated Feb 8, 2017 (v0.8.709) to incorporate feedback ❤️ Right, so the first thing you need to know is: I’m not Chrissy. My name’s Drew, and I’m here tell you about an exciting new release of dbatools: schwifty! In this release we’ve added three new commands to help you manage SPNs for SQL Server Kerberos authentication. If you have a lot of linked servers in your environment, then this is probably a welcome addition to the toolset for you.