Extend AlwaysOn SQL cluster in Azure – Step by step

Hi fellows, Over the past few days, I dealt with a client request to configure SQL AlwaysOn cluster in a hybrid environment. At the first look, that should have been a simple task, especially because I have configured AlwaysOn in dozens of projects. Unfortunately, project brought me a lot of problems during configuration, but I…

Read More

SQL AlwaysOn – Step by step

Hello everyone, In this post, I will describe process of configuring AlwaysOn on SQL Server 2016. Always On availability groups feature is a high-availability and disaster-recovery solution for your SQL databases. Before you start with configuring, you need to meet some prerequisites. For successful implementation, you need: SQL Server Standard 2016, or older in Enterprise…

Read More

How to install SQL Server 2016

This is a first post in “How to install” series. I will show you how to install SQL Server 2016, ie. how I like to install SQL Server, and for this purpose I will use SQL Server 2016 Enterprise edition. At the first place, hardware need to be prepared before installation. This means that the disks for…

Read More

How to check installed SQL components

Have you ever had the need to install an identical SQL server what you currently have? Of course, you need information about the installed components, but you’ve wondered how to easily do so. You can do that on two ways, and each of them are pretty simple.   Solution 1: Open start menu / screen on…

Read More

How to transfer logins and passwords between SQL Servers

In one of previous posts, Mismatch SQL account SID, you see how to find account SID and create new SQL account with same SID. With that queries you can manually do that, but if you don’t know password, you will still have same problem – incompatible account between SQL servers in cluster. Also, if you need to “replicate”…

Read More

Mismatch SQL account SID

My first project of creating highly available AlwaysOn SQL infrastructure was very challenging. Although I was prepared, and many tasks passed smoothly, I had a big problem after database failover. Database doesn’t work properly, and I had problem with orphaned user. After researching, found that SQL accounts are not same on both nodes although have a…

Read More