Hi gakambac,
User that login the SQL Server should be assigned to the CsArchivingAdministrator role.
According to your error message , the problem may caused by the "CONNECT SQL" permissions. you need the "CONNECT SQL" permissions for the security principle you’re using.The following
document is for your reference.
https://blogs.technet.microsoft.com/the_9z_by_chris_davis/2014/02/21/sql-event-id-18456-login-failed-for-user-reason-token-based-server-access-validation-failed/
You could check the steps that deploy Skype for Business Archiving Server
https://insidemstech.com/2015/07/13/deploy-skype-for-business-archiving-and-monitoring-server/
Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of
any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.
Best Regards,
Leon-Lu
TechNet Community Support
Please remember to
mark the replies as answers if they help and
unmark them if they provide no help.
If you have feedback for TechNet Subscriber Support, contact
tnmff@microsoft.com
