August 14, 2010 at 11:58 am
Hello All,
I have a SQL Server 2005 SP3 (x64 standard edition) instance that I recently changed the service account on the SQL Services and I've ran into an issue with Full Text Catalog. I was getting an error with the backups initially and unable to backup the one DB that had a full text catalog because the catalog was offline. I was unsuccessful in getting it online so I dropped the catalog, but now I can't readd it. Below is the error that I'm getting:
Msg 9955, Level 16, State 2, Line 2
SQL server failed to communicate with Full-Text Service (msftesql). The system administrator must make sure that same service account is used for both services and the service account has the permission to auto start the full-text service.
The same service account is being used for both services. I initially change the account in the services applet, but have gone back to SQL Server Configuration Manager to reapply the changes there. I've also verified that the new service account has full control the OS folder location where the catalog is being stored.
Full text search is running and can be stopped/started with no problems.
Any help would be greatly appreciated.
Shawn
August 15, 2010 at 4:01 am
Looks like you have not used the Configuration Manager to change the service account. Refer this
Change the service account using Configuration Manager. This should fix this issue.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply