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
Solved

Migrate Microsoft CRM 4

Posted on 2010-08-17
8
585 Views
Last Modified: 2013-11-24
Hi

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 ?
0
Comment
Question by:radut
8 Comments
 
LVL 7

Expert Comment

by:stacko111
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
0
 
LVL 9

Expert Comment

by:Biffster007
ID: 33459672
Hi,

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.

Cheers,
MH
0
 
LVL 4

Expert Comment

by:acstechee
ID: 33462328
Hi

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.
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

Author Comment

by:radut
ID: 33502278
Hi

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 ?
0
 
LVL 4

Expert Comment

by:acstechee
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
0
 

Author Comment

by:radut
ID: 33503755
Yes .. and there are 3 of those ..
0
 

Author Comment

by:radut
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 ?



0
 
LVL 4

Accepted Solution

by:
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.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying 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

Read about achieving the basic levels of HRIS security in the workplace.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

839 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