If you installed the Full-Text Search feature, it runs as the Microsoft Search service (MSSearch) in Control Panel. If full-text search is not working properly, make sure that the Full-Text Search feature was installed and is running. In SQL Server Service Manager, in the Services box, make sure the Microsoft Search option is selected. For more information, see How to start and stop the Microsoft Search Service for full-text support (Enterprise Manager).
MSSearch runs in the context of the local system account. During SQL Server Setup, SQL Server adds itself to MSSearch service as an administrator. All subsequent changes to the MSSQLServer service account must be made through SQL Server Enterprise Manager. While MSSearch service is running, right-click the server, click Properties, and then click the Security tab. Under Startup Service Account, enter the appropriate account and password. If the password is incorrect or has changed, the service cannot be started until the correct password is entered. This approach ensures that any service account change gets updated in the Microsoft Search service.
Caution Do not use Services in Control Panel to change user account information. Changing user account information through Control Panel results in a mismatch of account information between the MSSQLServer and MSSearch services, and causes full-text catalog population and querying to fail.
If a mismatch of user account information between the MSSQLServer and MSSearch services occurs, ensure that both the MSSQLServer and MSSearch services are running. Then, launch SQL Server Enterprise Manager. Using the Properties option and the Security tab as described earlier, change the password for the MSSQLServer service. Changing the password for the MSSQLServer service implicitly updates the account information for the MSSearch service.
Full-text Indexes | Full-text Query Architecture |
Full-text Indexing Support | Full-text Querying SQL Server Data |