SQL SERVER – Database Mirroring Login Attempt Failed with Error ‘Connection Handshake Failed’

One of my friends was trying to configure database mirroring and was having a hard time in getting things working. The challenge was that he was using certificate for mirroring authentication because machines were workgroup not in domain. He followed one of the blog from Microsoft site but still having problems.

Read More

SQL SERVER – How Enable Transparent Database Encryption (TDE) for Database Mirroring?

Life can teach you interesting lessons and push you beyond the boundary of what we call as a comfort zone. Recently I had a customer who was working on SQL server 2008 R2 and was enabling Mirroring. The very first thought was to recommend them to use AlwaysOn but that was not in their current scope because the application that they were working with was supported with SQL Server 2008 R2. The next thought for me was to understand what they were looking for as part of this consulting call. They incidentally wanted to enable Transparent Database Encryption (TDE) on their server and wanted me to guide on how to enable the same because the ISV had not done this before with a Database Mirroring configuration. So they were taking my help to understand how this needs to be systematically done with minimal downtime.

Read More

SQL SERVER – Mirroring Error 1412 – The remote copy of database has not been rolled forward to a point in time that is encompassed in the local copy of the database log. (Microsoft SQL Server, Error:)

With mirroring gone as deprecated feature, I have tried to keep away from exploring into what has been happening in this space. But what can I do when customers still use them? The challenges for consulting is pushing the boundaries of my comfort zone here. This made me revisit some of my learnings again. As part of this exercise, I learnt a minute or two which I personally felt was worth a share as part of this blog post. Here is a story for Mirroring Error 1412.

Read More

SQL SERVER – Database Mirroring login attempt failed – Connection handshake failed

The best way I have learnt about building SQL Server AlwaysOn Availability Group is by contacting my close friends who have written the only book on this topic. It is not common that I ping them for such technical queries, but that is what friendship is made off. Recently, while preparing a demo for the AlwaysOn Availability Group, I ran into interesting issue and was able to fix it as well. Let us learn about the Database Mirroring login error.

Read More

SQL SERVER – Mirroring Configured Without Domain – The server network address TCP://SQLServerName:5023 can not be reached or does not exist

Regular readers of my blog will be aware of my friend who called me few days ago with very a funny SQL Problem SQL SERVER – SSMS Query Command(s) completed successfully without ANY Results. This time, it did not take long before he called me up with another interesting problem,…
Read More

SQL SERVER – The server network address “TCP://SQLServer:5023” can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)

While doing SQL Mirroring, we receive the following as the most common error: The server network address “TCP://SQLServer:5023” cannot be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418) The solution to…
Read More
Menu