Solved

Troubles migrating CRM v3.0 DBs to staging environment

Posted on 2006-06-29
6
549 Views
Last Modified: 2013-11-24
Staging environment suffered major AD failure.  I am rebuilding it.

This is not SBS environment. We were a CRM 1.2 shop, upgraded to v3.0 two weeks ago.  Databases reside on a separate server.

Backed up databases and restored to staging SQL server and DB import was successful.  Did not name SQL instance (default).  Production and Staging server names are different hostnames.

When attempting to install CRM v3.0 PRO; I point it to the staging SQL box and when it attempts to attach to the existing DB's, I get the following error:

"The existing databases are not compatible with this installation of Microsoft CRM"

And setup silently exits at this point.  I would post the setup log, but really, it's right at the end of the log it simply refuses to think the DBs are compatible.  I've done some initial research and found what could be a multitude of issues causing this:

Different named SQL instance.  Anyone come across this before?
Restored DB's have different names (preface DB's with STGDB_Name_Date).  Anyone come across this before?

I read some other theories but they all applied to SBS installations and are not applicable to my environment.  

So my question is, should I bother with trying to recreate the exact environment? (Sans machine name) Or, do any of you have any experience with going from v1.2 -> v3.0 and STILL have the primary issue of "The existing databases are not compatible with this installation of Microsoft CRM"?

/denny
0
Comment
Question by:dennybvmc
  • 2
  • 2
6 Comments
 
LVL 16

Expert Comment

by:Redwulf__53
ID: 17016375
Did you restore JUST the _mscrm and _metabase db's and not the model db? If so, the security is out of whack. In that case, you'll need to run the Redeployment Wizard (located on the crm server CD) which will reconfigure all security related mappings.
0
 

Author Comment

by:dennybvmc
ID: 17020362
Redwulf:

Correct, I only restored the _mscrm and _metabase DB's from the production server to the staging server.

While waiting for input from the community here, I decided to back out on the install and do a "Fresh Install" into brand new databases in staging, but when I imported the customizations from our production CRM v3.0 we got an error message stating the customizations were also incompatible with this version of CRM v3.0.

Our next step is to uninstall v3.0, install v1.2, then upgrade the beast in staging and see where we get.

0
 

Author Comment

by:dennybvmc
ID: 17034299
Mark this as resolved.

Resolution was not to use my script to import the database; simply use the 'restore' in SQL feature to allow MS CRM installer to continue beyond DB version check.

Thanks all.
0
 
LVL 16

Expert Comment

by:Redwulf__53
ID: 17601385
agreed.
0
 

Accepted Solution

by:
CetusMOD earned 0 total points
ID: 17633453
PAQed with points refunded (500)

CetusMOD
Community Support Moderator
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
FRM-41076 and FRM-40735 errors 7 1,001
Enterprise Anti-virus solution 3 193
application contracts/SLA's 2 86
MIS vs ERP 11 237
"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

770 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