Categories

A sample text widget

Etiam pulvinar consectetur dolor sed malesuada. Ut convallis euismod dolor nec pretium. Nunc ut tristique massa.

Nam sodales mi vitae dolor ullamcorper et vulputate enim accumsan. Morbi orci magna, tincidunt vitae molestie nec, molestie at mi. Nulla nulla lorem, suscipit in posuere in, interdum non magna.

How to fix creating index (Full-Text catalogs) – Error 229 (Permission denied) in SQL Server?

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.

Comments are closed.