This is a MS SQL 2005 server. The full text search seems time out after some idle time. Interestingly, this time out only happens to ASP.NET connections. Query Analyzer never timed out no matter what login name used. This MS KB link explains it:
However, my server DOES have internet conneciton. Nevertheless, this command still fixed the problem:
sp_fulltext_service 'verify_signature', 0;
Even Microsoft says there are securities concerns but it doesn’t seem there is an option. To check the current configuration value without changing it, run
I had to restart SQL service for it to take effect.