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

Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

Question has a verified solution.

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

Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month13 days, 6 hours left to enroll

801 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