Wednesday, March 7, 2012

Problem Creating Full-Text Catalog on Pubs

I have just installed SQL Server 2005 Developer Edition and attached the Pubs database that is enabled for full-text searching and I have run full-text searches on it using Sql Server 2005 Express. When i tried to search, I was informed that the catalog was not in a stable condition. I ran this script

Drop FullText Catalog PubsCatalog

I got this message:

Warning: The fulltext catalog 'PubsCatalog' is being dropped and is currently set as default.

When I try to create a new PubsCatalog, I get:

Msg 7689, Level 16, State 1, Line 1
Execution of a full-text operation failed. 'The dependency service does not exist or has been marked for deletion.'

I have tried other catalog names but the same result.

This was easy to do with the same db in Sql Server 2005 Express. What is wrong and how do I fix it?

The problem seems to be related to Vista. Sql Server 2005 SP2 fixed it.

No comments:

Post a Comment