<p>I am trying to enable Full-text indexing in SQL Server 2005 Express. I am running this on my laptop with Vista Ultimate.</p>

<p>I understand that the standard version of SQL Server Express does not have full-text indexing. I have already downloaded and installed "Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 2" (<a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=5B5528B9-13E1-4DB9-A3FC-82116D598C3D&amp;displaylang=en" rel="noreferrer">download</a>).</p>

<p>I have also ensured that both the "SQL Server (instance)" and "SQL Server FullText Search (instance)" services are running on the same account which is "Network Service".</p>

<p>I have also selected the option to "Use full-text indexing" in the Database Properties > Files area.</p>

<p>I can run the sql query "SELECT fulltextserviceproperty('IsFulltextInstalled');" and return 1.</p>

<p>The problem I am having is that when I have my table open in design view and select "Manage FullText Index"; the full-text index window displays the message... </p>

<blockquote>
  <p>"Creation of the full-text index is not available. Check that you have the correct permissions or that full-text catalogs are defined."</p>
</blockquote>

<p>Any ideas on what to check or where to go next?</p>

[{'answer_id': 4139, 'author': 'csmba', 'author_id': 350, 'author_profile': 'https://Stackoverflow.com/users/350', 'pm_score': 5, 'selected': True, 'text': "<pre><code>sp_fulltext_database 'enable'\n\nCREATE FULLTEXT CATALOG [myFullText]\nWITH ACCENT_SENSITIVITY = ON\n\nCREATE FULLTEXT INDEX ON [dbo].[tblName] KEY INDEX [PK_something] ON [myFullText] WITH CHANGE_TRACKING AUTO\nALTER FULLTEXT INDEX ON [dbo].[otherTable] ADD ([Text])\nALTER FULLTEXT INDEX ON [dbo].[teyOtherTable] ENABLE\n</code></pre>\n"}, {'answer_id': 4717, 'author': 'Eddie', 'author_id': 576, 'author_profile': 'https://Stackoverflow.com/users/576', 'pm_score': 2, 'selected': False, 'text': '<p>All I needed to get full-text indexing to work was the...</p>\n\n<blockquote>\n  <p>CREATE FULLTEXT CATALOG [myFullText] WITH ACCENT_SENSITIVITY = ON</p>\n</blockquote>\n\n<p>After that I could run a CREATE FULLTEXT INDEX query or use the Manage FullText Index in MSSQL Management Studio.</p>\n'}, {'answer_id': 12140569, 'author': 'Nikhil Chavan', 'author_id': 1627443, 'author_profile': 'https://Stackoverflow.com/users/1627443', 'pm_score': 1, 'selected': False, 'text': '<p>Use sql server management studio.</p>\n\n<p>Login as admin to your windows account.</p>\n\n<p>Then select database and right click on database in sql server management studio and select Define Full Text Index and you are guided throughout the process by management studio.</p>\n'}]
['https://Stackoverflow.com/questions/4052', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/576/']