Error while configuring Sql server 2005 for full text search
Posted
by San
on Stack Overflow
See other posts from Stack Overflow
or by San
Published on 2010-03-15T07:09:48Z
Indexed on
2010/03/15
7:49 UTC
Read the original article
Hit count: 635
I am trying to index a table for full text search on a SQL server 2005.
When I select the change tracking as Automatic and click on the next button, I get the following error
TITLE: Microsoft SQL Server
This wizard will close because it encountered the following error:
------------------------------ ADDITIONAL INFORMATION:
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
The EXECUTE permission was denied on the object 'sp_help_category', database 'msdb', schema 'dbo'. The SELECT permission was denied on the object 'sysjobs_view', database 'msdb', schema 'dbo'. (Microsoft SQL Server, Error: 229)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4035&EvtSrc=MSSQLServer&EvtID=229&LinkId=20476
------------------------------ BUTTONS:
OK
© Stack Overflow or respective owner