Lync 2010 - Cannot update active Match Making server because SQL Server does not respond

So today I was digging through event viewer and saw some weird logs with the following error:

Cannot update active Match Making server because SQL Server does not respond.

The service failed to register an active Match Making because of a failure to connect to the SQL Server domainfrontend.local\rtc.
Exception: 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)
Inner Exception: ~

Cause: The server lost the connection to the backend database.
Resolution:
Make sure the machine has connectivity to the backend SQL Server.

After doing a quite Google search, nothing came up like usual, however I believe I have found a fix.  When installing the latest cumulative update for your front end server, make sure that you don't forget to run the following command (I forgot to finish the install running this command on my second front end, which is when these errors started to popup).

Install-CsDatabase -Update -ConfiguredDatabases -SqlServerFqdn <EEBE.Fqdn> -UseDefaultSqlPaths
Hope this helps!

1 thought on “Lync 2010 - Cannot update active Match Making server because SQL Server does not respond

  1. RX

    While this fixes some issues, please be aware that this will cause a *blip* in service so beware when you try this in production.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *