SQL SERVER – Unable to Set Cloud Witness. Error: The Client and Server Cannot Communicate, Because They do Not Possess a Common Algorithm

Recently, I was trying to simulate a client’s environment for which I need to have windows cluster with cloud witness. It didn’t go well, and I encountered an error message. In this blog, I will share the solution of error – “The client and server cannot communicate, because they do not possess a common algorithm” which I received while adding cloud witness. I was following below documentation: Deploy a Cloud Witness for a Failover Cluster

Read More

SQL SERVER – Creating Azure VM for SQL Server Using Portal

I need to admit that Microsoft has been investing big time on the Azure platform and the adoption has been great amongst customers. In the recent past, though I have made several performance tuning activities with customers on SQL Server – many have come back to me asking for consulting into migration into Azure. A lot of conversations have been around lift-and-shift application deployments on an Azure VM (Virtual Machine).

Read More