Symptoms:\r\nI have my development database on a SQL Server 2005 server. I enabled it for full-text catalogs and created a catalog with no issues whatsoever. When I go to create the index, however, I run through the wizard (usingÂ SQL Server Management Studio) until the last step. Upon finishing the wizard, I get the following error:\r\n\r\nError:\r\n
Failed to retrieve data for this request (Microsoft.SqlServer.SmoEnum)\r\nAdditional Information:\r\nA exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)\r\nEXECUTE permission denied on object 'sp_help_category', database 'msdb', schema 'dbo'.\r\nSELECT permission denied on object 'sysjobs_view', database 'msdb', schema 'dbo'. (Microsoft SQL Server, Error: 229)
\r\nI am theÂ DBOwner. TheÂ DBA created the index for me with no problems. I can see the index. I can pull up the property pages and see “General” and “Columns” views fine, but when I click on “Schedules”, I receive the same error as above.\r\n\r\nSolution:\r\nYou do not have permissions to accessÂ sysjobs_view in databaseÂ msdb and also executesp_help_category inÂ msdb.\r\nUser must haveÂ CREATE FULLTEXT CATALOG permission on this database, or be a member of thedb_owner, orÂ db_ddladmin fixed database roles.