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