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开发者_Python百科', 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
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.
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.
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.
精彩评论