Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Symptom

Consider the following scenario in Database Maintenance in Microsoft Dynamics SL:

  • You create a Windows Authenticated logon name for a Microsoft Dynamics SL user.

  • You change the user's username in Active Directory.

  • You open the Database Maintenance (98.290.00) screen, and then select Synchronize All Ownership and Security on the Update Databases tab.

  • You click Update Database.

When you do this, you receive the following error message:

ExecuteAuthenticationScripts Error -2147206479 [Microsoft] [ODBC SQL Server Driver] [SQL Server] The server principal '%' already exists.

Cause

This problem occurs because the Microsoft Dynamics SL user's username was changed in Active Directory but not in the Microsoft SQL Server that hosts the Microsoft Dynamics SL Databases.

Resolution

To resolve this problem, follow these steps:

  1. Change the user's logon name in the User Maintenance (96.260.00) screen to match the change that you made in Active Directory.

  2. Log on to Microsoft SQL Server Management Studio, and then delete the user's old logon name from the Logins folder.

  3. n the Logins folder in Microsoft SQL Server Management Studio, create the user's new logon name, and then verify that it is mapped to the correct Microsoft Dynamics SL roles.


More Information

Solomon Dynamics SL

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×