Right after setting up SQL Server 2005 cluster on Windows 2008; the FTE Services did not start up automatically. Following error gets recorded in the event log/cluster events:
Cluster resource ‘SQL Server Fulltext (InstanceName)’ in clustered service or application ‘VirtualClusterName’ failed.
Generic application ‘SQL Server Fulltext (InstanceName)’ could not be brought online (with error ‘1075’) during an attempt to start the service. Possible cause: the specified service parameters might be invalid.
Microsoft Engineer pointed me to KB936302, Problem #3; however said solution of install SP2 was not enough. The services still refused to come online, to make it so services started successfully we edited following registry entry:
Multi-String Value: DependsOnService
Value Changed from …
Rebooted each node; services came on successfully.