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:
-
Change the user's logon name in the User Maintenance (96.260.00) screen to match the change that you made in Active Directory.
-
Log on to Microsoft SQL Server Management Studio, and then delete the user's old logon name from the Logins folder.
-
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