SQL Server Agent would not start, and the log said Driver’s SQLAllocHandle on SQL_HANDLE_ENV failed. Here are the logs I check and the fix I found.
SQL SERVER – Unable to Start Jobs – Error: Enumerate Target Servers Failed for Job
They showed me below error when they were trying to run a job. Let us see how we can fix the error Enumerate Target Servers Failed for Job.
SQL SERVER- Unable to Failover AlwaysOn Availability Group to Disaster Recovery Site
A client added a DR node but was unable to failover AlwaysOn Availability Group to it. The listener had only one IP address, and here is the fix.
SQL SERVER – Patch Rule Failure: Not Clustered or the Cluster Service is Up and Online
A SQL Server 2016 service pack failed the rule “Not clustered or the cluster service is up and online”. Here is what Detail.txt showed and how we fixed it.
SQL SERVER – Maintenance Plan Error: Cannot Create a Task From XML For Task, Eue to Error 0x80070057. The Parameter is Incorrect. (OnPreExecute)
Creating a new maintenance plan on my virtual machine failed with cannot create a task from XML, error 0x80070057. Here is the fix that worked for me.
SQL SERVER – Don’t Ignore Warning: Cluster Resource DLL Update Restart Check
Patching a clustered SQL instance, setup warned: Cluster Resource DLL Update Restart Check. A hard lesson on why you should not ignore this warning.
SQL SERVER – Unable to Connect to SQL Server in Azure Virtual Machine from SSMS on On-Premise Machine
Can’t connect from SSMS on your own machine to SQL Server in an Azure Virtual Machine? Here is the network-related error users see and what to check to fix it.