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

Event ID 4113: Unexpected Error . . .

As Exchange administrator, did you ever seen event error log Event ID 4113: Unexpected Error When calling the Microsoft Exchange Active Directory Topology service on server? Event is repeated every 15 minutes, but everything works without problems. You must agree, the problem is totally weird and creating unnecessary anxiety. Especially when you find how to fix the problem….

Read More

How to upgrade Windows 2012 R2 evaluation to full version?

Although is Windows Server 2012 R2 “old” OS, before few weeks I had to license evaluation version of Windows Server 2012 R2. Process is very simple, but change the license key requires use of CLI instead GUI. By Microsoft, that is not “just” licensing, that is upgrade to Windows Server 2012 R2. At the first…

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