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!
LVL 1
PortableLightingAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Enterprise Software

From novice to tech pro — start learning today.