Running the Set Authentication Type in Database Maintenance doesn't fix synchronization issues between system.AcctXref and application.vs_AcctXref

  • Artículo

This article explains that running the Set Authentication Type in Database Maintenance (98.290) doesn't fix synchronization issues between system.AcctXref and application.vs_AcctXref.

Applies to:   Microsoft Dynamics SL 2011, Microsoft Dynamics SL 2011 Service Pack 1, Microsoft Dynamics SL 2011 Service Pack 2
Original KB number:   3060680

Symptoms

Running Set Authentication Type in Database Maintenance (98.290) doesn't fix synchronization issues between system.AcctXref and application.vs_AcctXref.

Resolution

To fix this issue, follow these steps:

  1. Delete the records in the vs_acctxref table in the application database(s).
  2. In Database Maintenance (98.290), run Set Authentication Type and select Windows Authentication. Which regenerates the records in the vs_acctxref table.