During my troubleshooting of a cluster issue I had, I tried to remove an
instance of SQL Server 2005 from the cluster - this failed, but it did
remove the Full text and SQL Agent resources. What's the best way to add
those back in as clustered resources? In services.msc the services have been
uninstalled - so they would need to be installed again. The SQL Server
resource is up and running just fine and fails over to all nodes successfully.

Thanks,
Mark.

You can try to go into Add/Remove programs, SQL 2005, and select REPAIR.
Not sure if this will actually fix your problem or not.

If not, you will need to backup the user databases, uninstall SQL and
reinstall SQL.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Mark Allison" <marka (AT) no (DOT) tinned.meat.mvps.org> wrote