Solved

Troubles migrating CRM v3.0 DBs to staging environment

Posted on 2006-06-29
6
543 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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Notes - my question 12 252
Mainframe to data base 5 190
OVM 3.2.8 - hard partitioning? 8 153
Acceptance of ERP in BFSI sector? 4 187
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-…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
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…

760 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

21 Experts available now in Live!

Get 1:1 Help Now