Nov 22, 2016 | Armin Odorfer

As a Microsoft Dynamics CRM partner, we sometimes have to import a customer database into our internal development environment. If the customer uses a language other than English in their Microsoft SQL server system, the following error may occur during import, shortly after the start of the Dynamics CRM Import Wizard:

1

Error| Import Organization (Name= , Id= ) failed with Exception:

System.Data.SqlClient.SqlException (0x80131904): The login already has an account under a different user name.

To solve this problem, call up the Microsoft SQL Management Studio within the corresponding database server. There, you can expand the organization database *_MSCRM to the database user level.

2

In our example (German source system, English destination system), we have to delete the login “NT-AUTORITÄT\NETZWERKDIENST“ for Dynamics CRM to be able to import the organization. In other language versions, delete the equivalent login.

3

If you delete the user, you also have to delete the connected schema.

4

Subsequently, you can import the database into the Dynamics CRM system without problems. The deleted login will be created anew with the English name “NT AUTHORITY\NETWORK SERVICE“.

I accept that this site uses cookies for analysis, personalized content and advertisment.