While writing my previous blogs about SQL Server Configuration Manager, I encountered another error. In this blog, we would learn one of the possible causes of error 0x80010108 – The object invoked has disconnected from its clients.
How to Identify Process ID for SQL Server Services? – Interview Question of the Week #185
Question: How to Identify Process ID for SQL Server Services?
How to Find Service Account for SQL Server and SQL Server Agent? – Interview Question of the Week #179
Question: How to Find Service Account for SQL Server and SQL Server Agent?
Answer: As they say – There are more ways than one to skin a cat. In this blog, we will find multiple methods to find out service account used for SQL Server service and SQL Agent Service
SQL SERVER – Unable to Add Node – Could not find subkey System \ CurrentControlSet \ Services \ MSSQLFDLauncher. Error code 0x851B0001
After a bit of testing on my lab server, I was able to reproduce the issue! We will not see a feature listed on the Features Page if the respective MSI file is missing from the Setup Media. Full-Text Search using the MSI called sql_fulltext.msi and is present in the setup path MediaRoot\x64\Setup. I was not able to see the sql_fulltext.msi file in the client’s setup media. I was suspecting other files to be missing too so we extracted a fresh copy of the setup media (from new downloaded ISO) and then ran the “New Failover Cluster” setup. This time, we were able to see Full-Text Search option. Let us learn how to fix the error related to unable to add node.
What is SQL Server Launchpad Service? – Interview Question of the Week #168
Question: What is SQL Server Launchpad Service?