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

Database Portability

Database portability is a feature that enables an Exchange Server mailbox database to be moved to or mounted on any other Mailbox server in the same organization, provided the target Mailbox server has databases with the same database schema version. You might be wondering why this is necessary, but I had a few cases where the…

Read More

Nested Virtualization on VMware ESXi 5.5

At one point of my testing of various technologies including Windows Server 2012 a few years ago, I needed a test environment with two or more physical servers which can host virtual machines. Since I didn’t have that kind of environment, I tried to create nested virtualization on VMware ESXi 5.5. My troubles began when…

Read More