Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
I am getting an error message when I am trying to import an organisation from the live to test environment. I Get the following error message The login already has an account under a different user name RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello
    I am trying to import a CRM 4 DB from live deployment to the test server. I have backed up the database ORG_MSCRM from the live and restored it on my test server. I renamed the database and when I try to import the organisation in the test server. I am having windows server 2008 r2 installed on the test server.   I always get the error further below.  The wizard from the delployment manager goes through fine,After I mapped the user, the error occurs immediately and mmc snap-in closes with error.

    Does anyone have a hint what could be wrong?

    Thanks and kind regards,
    Nemath

    Error:
    "System.Data.SqlClient.SqlException (0x80131904): The login already has an account under a different user name.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)
       at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command, Boolean capturePerfTrace)
       at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate, Boolean capturePerfTrace)
       at Microsoft.Crm.Setup.Database.SharedDatabaseUtility.CreateUser(CrmDbConnection connection, String user, Boolean enableTrace)
       at Microsoft.Crm.Setup.Database.SharedDatabaseUtility.GrantDboAccessHelper(CrmDbConnection connection, String user)
       at Microsoft.Crm.Setup.Database.DatabaseUtility.CreateUserAndGrantDboAccess(InstallDatabase database, String user)
       at Microsoft.Crm.Setup.Database.Helpers.GrantDboAccess(String user, Guid organizationId)
       at Microsoft.Crm.Setup.Database.DatabaseUtility.grantAccessInternal(String sqlAccessGroup, String reportingGroup, String privReportingGroup)
       at Microsoft.Crm.Setup.Database.DatabaseUtility.GrantAccess(String sqlAccessGroup, String reportingGroup, String privReportingGroup)
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.UpdateOUGroupsInDatabase(String sqlServerName, String databaseName, Guid organizationId)
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.ImportAndUpgrade(OrganizationInfo organizationInfo)
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.Execute(Object obj)
       at Microsoft.Crm.Tools.Admin.ProgressController.ExecuteHandler()"

    Monday, October 25, 2010 1:33 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Nemath,

    Are you mapping your users correctly? And are you redeploying the CRM as an Administrator with full network domain access rights? It looks like you are

    Please follow these steps: http://support.microsoft.com/kb/952934

    1. Import the organization into the new deployment of Microsoft Dynamics CRM 4.0. To do this, follow these steps:
    2. On the new computer that is running Microsoft Dynamics CRM Server, click Start, point to All Programs, point to Microsoft Dynamics CRM, and then click Deployment Manager.
    3. Right-click Organizations, and then click Import Organization.
    4. If you are using the Professional edition of Microsoft Dynamics CRM, you are prompted to delete the existing organization. Click OK to delete the organization that was created during the installation.

      Note This action does not delete the actual <var>Organization</var>_MSCRM database from the computer that is running SQL Server.
    5. In the SQL Server box, click the computer to which you restored the <var>Organization</var>_MSCRM database, click the organization database in the Organization database box, and then click Next.
    6. Type the display name and the name for the organization, and then click Next.
    7. Type the URL in the SQL Server Reporting Services URL box, and then click Next.
    8. Select the method in the Method for the Mapping of the Users list, and then click Next.
    9. Map the users, and then click Next.
    10. In the System Requirements dialog box, click Next, and then click Import.

    Also check this link as well http://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/99e8a122-02db-4d8e-9e39-b069c880da6e

    Regards

    TGB

    1. Click Start, point to All Programs, point to Microsoft Dynamics CRM, and then click Deployment Manager.
    2. Right-click Organizations, and then click Import Organization.
    Note If you do not have an Enterprise license key, you will be prompted to delete the organization that you created. This will not delete the SQL Server database. This will only remove the organization out of the Microsoft Dynamics CRM deployment.
    3. Type the SQL server name to which you restored the SQL Server database in the SQL Server box, select the organization database in the Orgnization database box, and then click Next.
    4. In the Display name field and in the Name field, type the organization name, and then click Next.
    Note The organization name is a unique name for the organization database. This organization name will be used in the URL to access the organization database. There is a 30 character limit for the organization name.
    5. In the Report Server URL box, type the URL address of the Report Server, and then click Next.
    6. In the Select Method for Mapping page, select a method to map users, and then click Next.
    7. As soon as all users are mapped, click Next.
    8. Click Next after the system requirements checks are completed.
    9.

    Click

    Microsoft Certified Business Management Solutions Specialist
    • Marked as answer by Nemath86 Tuesday, October 26, 2010 2:43 PM
    Monday, October 25, 2010 3:03 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Nemath,

    Are you mapping your users correctly? And are you redeploying the CRM as an Administrator with full network domain access rights? It looks like you are

    Please follow these steps: http://support.microsoft.com/kb/952934

    1. Import the organization into the new deployment of Microsoft Dynamics CRM 4.0. To do this, follow these steps:
    2. On the new computer that is running Microsoft Dynamics CRM Server, click Start, point to All Programs, point to Microsoft Dynamics CRM, and then click Deployment Manager.
    3. Right-click Organizations, and then click Import Organization.
    4. If you are using the Professional edition of Microsoft Dynamics CRM, you are prompted to delete the existing organization. Click OK to delete the organization that was created during the installation.

      Note This action does not delete the actual <var>Organization</var>_MSCRM database from the computer that is running SQL Server.
    5. In the SQL Server box, click the computer to which you restored the <var>Organization</var>_MSCRM database, click the organization database in the Organization database box, and then click Next.
    6. Type the display name and the name for the organization, and then click Next.
    7. Type the URL in the SQL Server Reporting Services URL box, and then click Next.
    8. Select the method in the Method for the Mapping of the Users list, and then click Next.
    9. Map the users, and then click Next.
    10. In the System Requirements dialog box, click Next, and then click Import.

    Also check this link as well http://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/99e8a122-02db-4d8e-9e39-b069c880da6e

    Regards

    TGB

    1. Click Start, point to All Programs, point to Microsoft Dynamics CRM, and then click Deployment Manager.
    2. Right-click Organizations, and then click Import Organization.
    Note If you do not have an Enterprise license key, you will be prompted to delete the organization that you created. This will not delete the SQL Server database. This will only remove the organization out of the Microsoft Dynamics CRM deployment.
    3. Type the SQL server name to which you restored the SQL Server database in the SQL Server box, select the organization database in the Orgnization database box, and then click Next.
    4. In the Display name field and in the Name field, type the organization name, and then click Next.
    Note The organization name is a unique name for the organization database. This organization name will be used in the URL to access the organization database. There is a 30 character limit for the organization name.
    5. In the Report Server URL box, type the URL address of the Report Server, and then click Next.
    6. In the Select Method for Mapping page, select a method to map users, and then click Next.
    7. As soon as all users are mapped, click Next.
    8. Click Next after the system requirements checks are completed.
    9.

    Click

    Microsoft Certified Business Management Solutions Specialist
    • Marked as answer by Nemath86 Tuesday, October 26, 2010 2:43 PM
    Monday, October 25, 2010 3:03 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Its a mapping problem. Try to map the users manually. Map just few users or just admin user and try if it works.

    I hope it helps.

    Amreek singh Senior CRM Consultant CDC Praxa Sydney, Australia http://mscrmshop.blogspot.com
    Monday, October 25, 2010 10:49 PM