Helping on a forum, I asked a user to test WMI with WBEMTest and it returned error 0x80041017, Invalid query. Here are the test steps and how to fix the error.
SQL SERVER – Install Error – The Reporting Services Catalog Database File Exists. Select a Reporting Services files-only mode installation
A remote command-line install of SQL Server failed with: The Reporting Services catalog database file exists. Here is how I helped my client fix it.
SQL SERVER – FIX: Error 17836: Length Specified in Network Packet Payload Did Not Match Number of Bytes Read; the Connection has been Closed
One of my clients reported that they are seeing below error in SQL Server ERRORLOG. He noticed a strange error of the network packet.
SQL SERVER – Unable to Load User-Specified Certificate [Cert Hash(sha1) “Thumbprint.here”]. The Server Will Not Accept a Connection
While preparing a security demo, I broke my SQL Server and it would not start: Unable to load user-specified certificate. Here is how I fixed error 26014.
How to Identify Process ID for SQL Server Services? – Interview Question of the Week #185
How do you find the Process ID for SQL Server services? One quick query on sys.dm_server_services returns the process id, status, last startup time and account.
SQL SERVER – ERROR: Failed to verify the Authenticode signature of FileName
SQL Server logged: Failed to verify the Authenticode signature of sqlservr.exe. Here is what the message means and why it can point to malware on the machine.
SQL SERVER – Scoped Firewall Rules Instead of Disabling the Firewall
A firewall rule should permit the required SQL Server or management connection narrowly. My original automation case needed remote access.