Inspect service startup type, current status, service account, and SQL TCP registry values, then compare configuration with live listeners.
Authentication Mode Greyed Out in SSMS: Read the Real Value
An authentication mode greyed out in SSMS means the Security page can’t show the value it reads. This post reads the real mode with SERVERPROPERTY, with the registry value SSMS uses and with the error log. It also explains what the two valid values mean and how a bad value is repaired.
Agent Service Missing in Configuration Manager: The Fix
An Agent service missing in Configuration Manager can come from a wrong program path. This post compares the service lists, reads the Agent path with T-SQL, checks that the file exists, and explains how to repair the path.
SQL SERVER – Event ID 7000 – The System Cannot Find the File Specified
This blog is from one that came from a DBA from one of my consulting engagements. Let us learn how to fix event id 7000 error.
SQL SERVER – SQL Server Configuration Manager Missing from Start Menu
SQL Server Configuration Manager missing from the Start Menu? Open it directly from C:\Windows\System32 with the SQLServerManager msc file for your version.
SQL SERVER – Slow SQL Server 2016 Installation in Cluster: RunRemoteDiscoveryAction
A client’s SQL Server 2016 Installation in Cluster hung at RunRemoteDiscoveryAction while setup ran discovery on the other node. Here is the cause of the delay.
SQL SERVER – Unable to Failover SQL Server Instance – Error: Registry Information is Corrupt or Missing
A client could not failover SQL Server to another node: registry information is corrupt or missing. Here is how I found the right error in the logs.