Error while configuring Sql server 2005 for full text search
- by San
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:
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server+Management+Studio&ProdVer=9.00.4035.00&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476
------------------------------ 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