Site Sponsored By: SQLDSC - SQL Server Desired State Configuration
Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
I'm having trouble setting up full text search on my database. I have been unable to create a fulltext catalog. I get the following message when I try:========================================================Full-Text Indexing Wizard Progress- Create full-text catalog TextCatalog (Error) Messages * Create full-text catalog failed. ------------------------------ ADDITIONAL INFORMATION: Create failed for FullTextCatalog 'TextCatalog'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+FullTextCatalog&LinkId=20476 ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Execution of a full-text operation failed. 'Server execution failed' (Microsoft SQL Server, Error: 7689) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4035&EvtSrc=MSSQLServer&EvtID=7689&LinkId=20476 - Create full-text index on eBay_Items.Current_Items (Stopped)========================================================Also, in management studio when I try to run Management>Full-Text Search>Start I get the message :The msftesql service on EMERAC started and then stopped (explorer)What can I do about this?