Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Migrate Microsoft CRM 4

Posted on 2010-08-17
Medium Priority
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 http://support.microsoft.com/kb/952934

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.
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.


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 2000 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

These days socially coordinated efforts have turned into a critical requirement for enterprises.
Let’s face it: one of the reasons your organization chose a SaaS solution (whether Microsoft Dynamics 365, Netsuite or SAP) is that it is subscription-based. The upkeep is done. Or so you think.
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

618 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