Arvind kum articles

Arvind kum
Published 
1 min read

“CREATE USER” SQL Error when creating and Synchronising New User in Dynamics NAV 2009 

In Dynamics NAV 2009 Service Pack 1 also later Builds on SQL Server 2005, SQL Server 2008 also SQL Server 2008 R2, when a new user is created and synchronised sometimes following error is thrown. 15023, “42000” User, group, or role ‘<Name>’ already exists in the current database. SQL: CREATE USER [<Name>] FOR LOGIN [<Name>] Possible