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.