Tuesday, November 29, 2011

CRM 2011 - Import Organization - Errorcode: 0x80131904 The login already has an account under a different user name

Using Import Organization on a CRM 4 Database results in
Errorcode: 0x80131904 The login already has an account under a different user name

The problem are different users and schemas in the sql-database of the installed system (CRM2011) and the source system (CRM4). The system language of the CRM 2011 database is another language than the CRM 4 database has been.


Example (de/en):

CRM 4 based on Windows Server 2003 / SQL 2005 GERMAN
CRM 2011 based Windows Server 2008 R2 / SQL 2008 ENGLISH

The german systems contains the user and schema 'NT-AUTORITÄT\NETZWERKDIENST'.
CRM 2011 database contains an user and a schema 'NT AUTHORITY\NETWORK SERVICE'. This is what the CRM 2011 system is expecting in the import org database.

Solution:

  • Create Database with name of CRM 4 source (_MSCRM) in SQL-Server of CRM 2011
  • Restore from backup of CRM 4
  • Delete the user and schema 'NT-AUTORITÄT\NETZWERKDIENST' from restored database
  • Use Deploymentmanager and import the organization
Cheers,
Markus

8 comments: