SQL Server Agent would not start in my lab: Failed to initialize SQL Agent log (reason: Access is denied). Here is what I found in the log folder and the fix.
SQL SERVER – All the Features not Listed While Installing SQL Server
Analysis, Reporting and Integration Services were missing from the Features page while installing SQL Server. The cause was missing MSI files in my setup media.
SQL SERVER – Always On Replica Disconnected After Changing SQL Server Service Account
After I changed the SQL Server service account in my lab, the Always On secondary replica went disconnected. Here is why the endpoint rejects the new account.
How to Enable Files & Folders Level Auditing in SQL Server? – Interview Question of the Week #176
Files kept vanishing from a client’s SQL Server Binn folder. SQL Server cannot track that, so here is how to enable Files and Folders Level Auditing in Windows.
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.
Upgrading Subscription Settings and System Objects Error in SQL Server Upgrade
Upgrading subscription settings is an upgrade step, and in this 2018 client case it failed on a missing replication table. This post shows tested queries for replication flags and the Distributor, how the Msg 208 for the missing table looks, and what the original fix with sp_removedbreplication did and did not touch.
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.