Lync Connector synchronization fails with SQL login error "Failed to export data from the Lync archiving database"

book

Article ID: 100015457

calendar_today

Updated On:

Description

Error Message

The Lync Connector synchronization fails with the following SQL login error, or another SQL permission error:

Failed to export data from the Lync archiving database. Login failed for user domain\user

where domain\user refers to the Arctera Unified Platform Lync Connector service account.

Cause

The Arctera Unified Platform Lync Connector service account runs the PowerShell cmdlet Export-CsArchivingData to extract data from the Lync archiving database. Microsoft's documentation suggests that membership of the Active Directory administrators group RTCUniversalServerAdmins is sufficient to run this cmdlet. However, in some Lync Server environments it has been observed that explicit SQL database permissions are required.

Resolution

This issue may be resolved by assigning the ServerRole database role in LcsLog -- the Lync archiving database -- to the Lync Connector service account, or to a group to which the service account belongs, such as RTCUniversalServerAdmins.  

Alternatively you can add the Lync Connector service account to an Active Directory group that has been assigned the ServerRole role in the LcsLog database, for example RTCComponentUniversalServices.  Be aware however, that membership of such a group may confer many more permissions than are required to perform the Lync data extraction. You must restart the Arctera Unified Platform Lync Connector service for this change to take effect.

Issue/Introduction

Arctera Unified Platform Lync Connector synchronization may fail in some Lync Server environments with a SQL login error, indicating that there was a failure to export data from the Lync archiving database.

Powered by Wolken Software