Problem Description
=================
Following the Lync Deployment Wizard to setup Database mirroring with a witness for Lync, it fails.
Story
=================
1. When I filled all the blanks in Deployment Wizard, and tried to publish topology, I got the following errors in report.
· Overall status: "Completed with errors"
· Error I Get log:
But if I tried to use UDL file to connect to the LYNCDB2, I succeeded.
2. I Run the Publish Topology Wizard again, shows no error. Here are the question, does this no error means mirror succeeded?
3. Check the status of any Lync database, it shows:
4. Go to primary, mirror, and witness and check status. I saw:
· Databases in Primary is OK, only is not configured for mirroring.
· Databases in Mirror Show status of "in Recovery".
· There is no Lync databases in Witness SQL instance.
5. Go to the mirroring file share, I can see full backup and transaction log backup. So, the preparation for mirror should is OK.
6. Tried to manually setup mirroring in Primary, failed. Because databases in Mirror are in ' in Recovery ' status. Databases in ' in Recovery ' status cannot be modified, and cannot is deleted.
7. To continue, we had to get rid of the ' in Recovery ' status in mirror instance. Use command below, and we can get a database change status to "Restoring".
8. Tried to manually setup mirroring again. But the database would change status back to ' in Recovery '. Back to starting point.
9. Read error log, we can see error below:
Database Mirroring login attempt failed with error: ' Connection handshake failed. There is no compatible encryption algorithm. State 22. '. [client:172.24.15.147]
Following this error message, we run the following SQL statement on primary, mirror, witness.
We found that primary and witness shows "RC4" while the Mirror shows "AES"
Run the following SQL statements to drop and recreate a new mirroring endpoint on mirror instance.
Run the following SQL statement to remove each problem databases from mirroring, and the status of those databases wil L Show "Restoring".
Manually setup SQL mirroring for a database, we finally succeeded.
Primary database shows status as below:
Mirror database shows status as below:
Continue the steps for other Lync DBs, and we'll have mirrored backend setup finished.
Summary
======================
Following Wizard of Lync expecting the wizard would automatically setup database mirroring for me, but didn ' t end Up as expected.
Lync Oddly created mirroring endpoints using different encrypt methods, and "RC4", one is of "AES " ”. Totally comes out of nowhere. -_-||
This caused a series of problems and troubleshooting. I have the gone through so many articles to get this over with. Microsoft ...
Articles that helped with this troubleshooting
======================
Troubleshooting SQL Server Database mirroring problems with best practices:requirements, and the 64-bit benefit
http://www.sqlservercentral.com/blogs/hugo/2009/11/11/ troubleshooting-sql-server-database-mirroring-problems-with-best-practices-requirements-and-the-64-bit-benefit/
Remove Database Mirroring (SQL Server)
Https://msdn.microsoft.com/en-us/library/ms190471.aspx
SQL Server–the SERVER Network address "Tcp://sqlserver:5023″can not being reached or does not exist. Check the network address name and the ports for the local and remote endpoints is operational. (Microsoft SQL Server, error:1418) http://blog.sqlauthority.com/2010/01/11/ the-server-network-address-tcpsqlserver5023-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-microso/https://msdn.microsoft.com/en-sg/library/ Ms187050.aspx
View the state of a mirrored Database (SQL Server Management Studio)
Https://msdn.microsoft.com/en-sg/library/ms187050.aspx
Resolution of an error encountered in Lync 2013 installation about SQL mirroring