Authentication

Test-DbaKerberos

Claude + Andreas Jordan

Test-DbaKerberos View Source Claude + Andreas Jordan Windows, Linux, macOS Synopsis Tests Kerberos authentication configuration for SQL Server instances by performing comprehensive diagnostic checks Description This function performs a comprehensive suite of diagnostic checks to troubleshoot Kerberos authentication issues for SQL Server instances. It addresses the most common causes of Kerberos authentication failures including SPN configuration problems, DNS issues, time synchronization errors, service account configuration, network connectivity problems, and security policy misconfigurations.

Using Set-DbaCmConnection to Reset Credentials and Cached Connection Status

Gareth N

Hi, I am Gareth N - a SQL Server DBA in the UK. I have started to blog over at ifexists.blog - today I want to share some information around how dbatools can cache connection information, and how to reset it. dbatools is smart. It can do things in the background when you’re using the commands, like cache connections and also cache the results of those connections. This can help speed things up as it will re-use the existing object.