Solved

Steps to relocate CRM 3.0 install to a new CRM 4.0 server and DB server

Posted on 2008-06-17
12
671 Views
Last Modified: 2013-11-24
Hi there,

I need assistance in redeploying my Microsoft CRM 3.0 installation to a CRM 4.0 installation to a new server. My current environment is as follows:
App Server:
- Win 2K3 sp1
- CRM 3.0 with update rollup 2
- SQL Server Reporting Server 2000 (for hosting CRM Reports)

Database Server:
- Win 2000 sp4
- SQL Server 2000 sp4 (default instance)
- Hosts "ReportServer" and "ReportServer_tempDB" databases for Reporting Services on App Server
- Hosts "CompanyName_METABASE" and "CompanyName_MSCRM" databases for CRM 3.0 application

My proposed environment:
App Server:
- Win 2k3 with CRM 4.0 application

DB Server:
- SQL 2005 Ent cluster with sp1 instance (hosts other databases on this instance)

Reporting Server:
- SQL 2005 Reporting Services (want to have a separate install of Reporting Services that is used by CRM 4.0 to host reports, but also want to use this reporting server for other custom reporting)

Basically, I thought the first step would be to get my 2 databases "CompanyName_METABASE" and "CompanyName_MSCRM" onto my SQL 2005 server and use the "Deployment Manager" installed on CRM 3.0 server by default to "configure the SQL server" to the new Database server and instance. This seemed straight forward and I followed a MS article, but failed with authentication issues on the database after following article exactly.
http://support.microsoft.com/kb/917948

My main aim is to get CRM 4.0 installed into my environment with a method that allows a good fallback option if required and to be able to get my existing data and customisations into the new CRM 4.0 installation.

Any assistance with regards to this process would be greatly appreciated.

Thanks.
0
Comment
Question by:kineticexpert
  • 5
  • 5
  • 2
12 Comments
 
LVL 9

Accepted Solution

by:
Biffster007 earned 500 total points
ID: 21808750
Hi,

I would do a CRM 3.0 redeployment to the new server then upgrade to CRM 4.0 after that.

Try doing the following steps for the redployment to the new servers...

1) Backup your current CRM databases
2) Uninstall CRM from Add/Remove Programs
3) Delete the 'Microsoft CRM' folder and all it's contents from the Program Files group
4) Delete the Microsoft CRM website from the IIS console
5) Delete the four CRM groups from the Organisational unit you selected when you installed CRM
6) Delete both the current CRM databases
7) Attach the previous 2 CRM databases that you have
8) Install the CRM Redeployment Wizard located on the CRM 3.0 disk
9) Run the Redeployment Wizard mapping old users to current users
10) Install CRM, specifying the same Organisation Name as the original installation, using the Connect to existing database option and continue with the setup

Then upgrade to CRM 4.0 after successful completeion of the above.

Cheers,
MH
0
 
LVL 15

Expert Comment

by:WilyGuy
ID: 22626948
I will weigh in a bit here:
A Redeployment is a fine option, but doesn't give the rollback I think that you want.

-Apply SP2 to SQL 2005 (it is a requirement for CRM 4 and you'll have to do it before or after  getting CRM working to the new server.
- Backup and Restore Metabase and MSCRM to new Server.
- likely you will want to script out the 4 MSCRM based jobs there as well and import them on new server.
- With both sets of DBs active, open the Deployment Manager and change the location of the SQL Server.
- Take the original DBs offline (don't switch SRS at this point).
- Test CRM from original CRM server.
- Build SRS server using SQL 2005 and SP2.  Put the Databases on new SQL server.
- Republish CRM Reports from first server using http://www.microsoft.com/dynamics/crm/using/deploy/changesrs.mspx as guide.

- If your new proposed CRM server is NOT 64 bit, install CRM 3.0 on it. Using Existing DB option - point to new SRS for now. (Reports MAY NOT WORK due to Kerberos Double Hop)
- Make sure any custom code is moved over.

- Backup DBs before upgrading (for rollback if necessary)

- At this point I will assume your system is "upgradeable" (there are plenty of good gotcha posts here and on the internet for upgrade issues)
- Upgrade the New CRM Server to CRM 4.0


This gives you OLD SQL 2000 server, untouched (to roll back if SQL move fails)
AND OLD CRM server to rollback to if Upgrade Fails
0
 

Author Comment

by:kineticexpert
ID: 22630737
Thanks for both posts guys. This redployment I am facing took a back seat for a while and probably because I never felt comfrotable with tackling this one without a good failback option.

WilyGuy - I like your approach and am thinking to attempt this method.

- I agree first step is to upgrade to SP2, trying to get this scheduled in, but my setup is a single instance with a number of databases and need to go through thorough testing prior to making this upgrade, hence the delay to date. I assume there is no issues in hosting my CRM databases on this instance and then when doing the new install of CRM 3 using existing DB option, will work fine and further work fine with upgrading to CRM 4?

- sorry, only got basic SQL skills - I am not sure on the process to "script out" the existing CRM jobs, is this simply right click on job and "Generate SQL Script", then check out the preview and paste that into a SQL query on the SQL 2005 server and execute and it should create the job? Can you please let me know all the jobs that need to come across? I see other random ones, possibly from other databases.

- I am using my new CRM server as my Reporting Server, as I only need to use SQL 2005 reporting Services for CRM...so can you confirm I would sitll be able to just build up my CRM server and install Reporting Services and complete the switch as per instructions above and later install CRM 3 as per instructions above?

- How do I check where there is custom code and also relocate it? Originally we had a 3rd party doing some work, most of it was reports, but I don't have documentation of any custom code being created, so want to make sure I relocate that.

Thanks heaps for the assistance so far.
0
 
LVL 15

Expert Comment

by:WilyGuy
ID: 22633063
Your CRM 3.0 DBs should be fine on the SQL 2005 at SP1, I just made the comment because many people have apprehensions about applying an SP with production databases.  This is already the case for you though since other DBs are there.

The "Script Out" is exactly what you describe, right click, generate the script and it should save as an .sql file.  You can put this on the new server and double click it (then it will open in the new SQL Studio and you can jut hit the Execute button.  There are likely other Maintenance jobs that you should probably confer with a DBA to determine if they should come over.  There are 4 main jobs that begin with MSCRM.

So NEW CRM box is also SRS....that's fine.  I would install SRS ahead of time (since it is 2005 version) and point that to the new server.  Depending upon order of operations, you would have SRS 2005 on NEWCRM pointing to NEWSQL, then on OLDCRM deployment manager, change the location of SRS.  Then from the OLDCRM, you can republish the reports.  Then you can install CRM 3.0 on NEWCRM with the USE Existing DB option.  Point SRS to the SRS you set up previously on NEWCRM.

Custom code for CRM 3.0 can be in a few locations.  My favorite place for Callouts (customizing CRM can be with Callouts, Customization (already in the database), Workflows, and Reports (may or may not be in the republish, so verify).  To look for callouts, look for a file called callout_config, likely in C:\PF\MSCRM\Server\Bin\Assembly (some abbreviation of file structure).
0
 
LVL 15

Expert Comment

by:WilyGuy
ID: 23271467
So how did the upgrade go?
0
 

Author Comment

by:kineticexpert
ID: 23828443
Hi guys,
I have not ended up completing this. After some time, we have found we are not going to upgrade as we are looking at decommisioning the product as it is not being used to its potential and is a bit of an overhead at present. If we ever need it again, we will be looking at starting from a fresh install of the latest version.

Thanks for your assistance.
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 

Author Comment

by:kineticexpert
ID: 23828445
P.S. Anyone know how to close of this posting without accepting it as a correct solution?
0
 
LVL 15

Expert Comment

by:WilyGuy
ID: 23830799
Well, both Biffster and I gave you solutions.  I would accept them.

You wouldn't get a refund anyway after so much time and solutions offered.  Just split the points.
0
 
LVL 9

Expert Comment

by:Biffster007
ID: 23831155
I agree...

MH
0
 

Author Comment

by:kineticexpert
ID: 23832141
It didn't give me the option to allocate points? Did you both get points on this?
0
 
LVL 15

Expert Comment

by:WilyGuy
ID: 23835550
I didn't, Biffster appears to have.  No big deal, so long as the question is closed.
0
 

Author Comment

by:kineticexpert
ID: 23842377
Sorry WilyGuy. Thanks for your assistance.
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

I showed you how to use console view (HERE (http://www.experts-exchange.com/articles/18379/Getting-Started-and-Using-the-Salesforce-com-Console.html)) -– but how do you set it up on the admin side of Salesforce? Note that you have to have Admin leve…
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

747 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now