Migrate Microsoft CRM 4

Posted on 2010-08-17
Last Modified: 2013-11-24

I have to Migrate a MS CRM 4 from an old server to a new sbs.

I have to migrate the DB and the CRM 4, there is the same AD.

What is the bedste practice ?

Shell i install the new DB CRM 4 on 2005 sql or on 2008 sql ?
Question by:radut
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Expert Comment

ID: 33457513
The best practice is at this link

You want the section titled:
Redeploy the Microsoft Dynamics CRM deployment that includes the Microsoft Dynamics CRM Server within the same domain or to another domain.

You can install on either SQL 2005 or 2008, it shouldn't make a difference

Expert Comment

ID: 33459672

Yep, look at the above section.  I would recommend moving to SQL 2008.  When version 5 is released you may as well have the software base already in place.


Expert Comment

ID: 33462328

If you can get SQL 2008 R2 running it gives some great new tools with the reporting services that the users seem to like.
The migration itself seemed to go quite smoothly when we did it here as long as you follow the steps in the article above you should be ok.
If you do decide to install with SQL 2008 R2 then make sure you run the setup updates when you install it and try to install on the default instance if possible, otherwise you need to bypass some of the setup checks.
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.


Author Comment

ID: 33502278

To things..

1. Where do i se what the DB is in the old CRM, i can se 3. and the installguide app where i can change the organisation will not start up.

2. and the one in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM dos not look like it

3. where do i find the key for the CRM ?

Expert Comment

ID: 33502340
Hi Radut

Most likely the database will be the default instance on the server the sql is installed. From there you can use SQL to find the location of the database.

I would image you will find it in c:\program files\Microsoft SQL Server\MSSQL and the database will be called your company name

Author Comment

ID: 33503755
Yes .. and there are 3 of those ..

Author Comment

ID: 33504719
I get an error form this :

g. Select the method in the Method for the Mapping of the Users list, and then click Next.

The error:
At least must the instaltion user be added before this organisaction is importet.

But the user .. Administrator is added..  

What do i do ?


Accepted Solution

acstechee earned 500 total points
ID: 33577099
Have you tried choosing to map the users manually? This should advise and you can see where a user might not be mapped.

The other thing to watch for is that the installation user might not be the administrator account. Look for other accounts that might have been used to install this.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question