Error while configuring Sql server 2005 for full text search

Question

I am trying to index a table for full text search in 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

Answer 1

It looks like the user trying to do the updates (as Kane said, perhaps a service account, or you) doesn't have sufficient permissions to perform that operation. It looks like the user needs to be generally elevated, or granted specific rights for those two objects.

Answer 2

You do not have the necessary permission to configure fulltext from SSMS. Ask an administrator to give you the necessary privileges, or ask the administrator to configure the fulltext for you.

Answer 3

Solution: I got the problem, I used to login using sql authentication. One has to login using windows authentication, to have the required permissions.

Its gonna be a problem, I guess, when I configure the sql server 2005 for full text search of my hosting provider. Because the only way I have access to that database is via sql authentication.