Solved

Troubles migrating CRM v3.0 DBs to staging environment

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
CMDB for MSSQL business apps 2 305
ACT for Sage 2013 6 911
ABAP TRANSPORTING clause issue 6 72
application software support 5 86
If you have problems displaying reports in CRM after a new installation, review the following steps: Check that SQL Server Reporting Services is working On the server that has SQL Server Reporting Services (SQL SRS) installed, check that the S…
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-…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

920 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

13 Experts available now in Live!

Get 1:1 Help Now