[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1706
  • Last Modified:

Upgrading Microsoft Dynamics CRM 3.0 to 4.0 pre-install issues

Hello Experts,

We are trying to upgrade from Microsoft CRM 3.0 to 4.0 (due to some features we like) but the pre-installation "checks" fail with the following message:

The full-text indexes on the Microsoft Dynamics CRM database are not consistent with Microsoft Dynamics CRM 3.0 full-text indexes

We had never used (or created) a full text index. The first time we tried to upgrade the CRM, the pre-install reported that the full text index was missing, so I created a dummy one thinking it would solve the problem.
But it lead to the most recent message posted above and I have since deleted the full-text index I created.

I am not very SQL savvy but welcome any advice to get beyond this issue.

We are running this on SBS 2003 R2 Premium with SQL 2005.

Thanks!
0
PortableLighting
Asked:
PortableLighting
  • 6
  • 4
1 Solution
 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
Have you updated SQL 2005 with http://support.microsoft.com/kb/936305 ?

Jeff
TechSoEasy
0
 
PortableLightingAuthor Commented:
TechSoEasy,

Thank you for responding. This question went several days without a single comment and I thought it may be hopeless.

I looked through the installed programs/patches and did not find KB936305 installed.
Our currnet SQL 2005 build is at 3054.

I assume you think this may clear up the problem we are having?
I will go ahead and schedule the install.

Thank you so much!
I will keep you posted.
 
0
 
PortableLightingAuthor Commented:
One other question...

I see MS has SQL build releases up tp 3215.
KB936305 (the one you brought to my attention) is only build 3175.

Would it just be best to bump our instance up to 3215?
Or are their reasons for incremental updates?

Thanks in advance.
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
For sure you want to bring it fully up-to-date, but to resolve your problem you need to have AT LEAST 3175.

Jeff
TechSoEasy
0
 
PortableLightingAuthor Commented:
TechSoEasy,

I can't find a link to download the patch you suggested. I could only find a request submission form on Microsoft's website. Any ideas where I could gain access to the patch?

0
 
PortableLightingAuthor Commented:
TechSoEasy,

I just applied the update you mentioned, SQL 2005 Build is now at 2175.

I am getting the same error when running the CRM 4.0 installer.

Any other thoughts?

Thanks
0
 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
Okay, I reread over all of this... and sorry that I didn't suggest this at first... you say you created a "dummy" one and then deleted it?  Normally, you wouldn't even enable full text indexing on a CRM 3.0 database as I have described here:  http:Q_22110481.html

Perhaps you just need to disable it?

Jeff
TechSoEasy
0
 
PortableLightingAuthor Commented:
TechSoEasy,

You ARE a Genius!

I disabled the Full text Indexing on the CRM database properties with the SQL Server Management Studio (didn't even realize it was an option) and ran the CRM 4.0 setup.
It no longer complains about the Full Text Indexing and now the "Next>" button is accessible.

One other question though before I close this.... everytime the CRM 4.0 pre-install check runs, it warns that:
 "Setup has detected a pending computer restart. Skipping the restart might cause errors during Setup."
This happens no matter how many times I reboot. I figured I would just ignore it for the upgrade, but just wondered if you had encountered anything like it.

Thank you so much for your help!
0
 
Jeffrey Kane - TechSoEasyPrincipal ConsultantCommented:
I've not seen that with CRM 4.0, but apparently it does happen and it's not important:
http://groups.google.com/group/microsoft.public.crm.deployment/browse_thread/thread/800cd9b8ceb1e6fd/60b986df7867dab9?hl=en

Jeff
TechSoEasy
0
 
PortableLightingAuthor Commented:
Thanks for all your help TechSoEasy.

We are going to attempt the install/upgrade tonight.

Hopefully, it will go smoothly.


0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now