Install-CsMirrorDatabase Failed on SFB 2015/Lync 2013
Few days ago, I was installing Skype for Business 2015 for a client when I came across this error. Setup was quite simple as 3 Front End servers in Lync Pool, 2 Back End SQL Servers, 1 File Share & SQL Witness Server. When I reached to the point to publish topology, I encountered this error that Install-CsMirrorDatabase Failed. Upon checking the Skype for Business Server 2015 Deployment log, I found full error.
Error: An error occurred: “Microsoft.Rtc.Management.Deployment.MirrorDatabaseException” “Cannot setup mirroring because there is an error validating the version of the SQL Server instances. Verify that the SQL Server instances are available. Exception: Microsoft.SqlServer.Management.Common.ConnectionFailureException: Failed to connect to server RFPHOVS050.alraffd.gov.om\SQLEXPRESS. —> System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified)
Creating Mirror Database Server.domain Completed with warnings
Error was clearly pointing that there is communication error between SQL Server nodes and SQL witness node. However, there was no firewall between servers. I started troubleshooting and found there are settings which should be changed on Witness node for proper communication with SQL Nodes.
- SQL Server Agent (SQLEXPRESS) Service which was disabled by default, should be Automatic and in running state.
- In SQL Server Configuration Manager, Enable the TCP/IP for Protocols for SQLEXPRESS
Once these changes made, you need to install/upgrade database using SFB/Lync Topology Builder and it will create mirror database successfully.