Event Error 56102

Question

Lync Server 2013 always show this Event error, it shows as below:
A Data Collection Archiving adaptor was either unable to obtain the database version, or a database version mismatch was detected. The adaptor will continue to try and reconnect to the back-end.

Adaptor: SQL Archiving Adaptor
Connection String: Data Source = backend SQL Server;
Database = LcsLog;
Max Pool Size = 5;
Connection Timeout = 60;
Connection Reset = false;
Enlist = false;
Integrated Security = true;
Pooling = true;
Expected Schema Version: 24
Expected Sproc Version: 40
Actual Schema Version:
Actual Sproc Version:
Cause: This typically occurs due to an installation error
Resolution:
Verify the back-end is up and this Lync Server has connectivity to it. Verify that both Lync Server and the back-end were installed or modified by the same installation package.

Answer 1

Hi EvanJiang-2564,

Do you check if the SQL services are running?

You can run the following command to verify connectivity for the Archiving database:

Test-CsDatabase -DatabaseType "Archiving" -SqlServerFqdn "atl-sql-001.litwareinc.com" -SqlInstanceName "archinst"  

Then, run the following command to verify if you have installed the expected version:

Test-CsDatabase -ConfiguredDatabases -SqlServerFqdn sql01.domain.com | Select SqlServerFqdn, SqlInstanceName, DatabaseName, InstalledVersion, ExpectedVersion | ft -AutoSize  

For more details, please refer to https://learn.microsoft.com/en-us/powershell/module/skype/test-csdatabase?view=skype-ps.