var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQL Full Text Search
We are having a problem with full text search.
Our server has recently been down graded from enterpise to standard eddition SP3.
I have reset the SQL Service account to local admin using enterpise manager but when i try to populate the full text catalogue I get an item count of 0.
I have reregistered all dlls in the mssearch\bin directory and the language key in HKLM\software\micorsoft\search\1.0\neutral doesn't exist.
Both the MSSearch and SQL services are running under the local admin account, and the built\administrators account is a sysadmin.
Any help will be much apreciated.. pulling my hair out on this one.
WHat is the error while populating?
Review SQL Server error log or run PROFILER during the process.
Try to reinstall FULLTEXT search on the downgraded version of SQL.
Event Log 3024
The crawl for project <SQLServer SQL0001600005> could not be started, because no crawl seeds could be accessed. Fix the errors and try the crawl again.
Can i just reinstall MSSearch if so how do i go about this?
MSSearch must be running under local system account as specified in this KBA
I've also found this article, both SQL and MSSearch Services are running under the local system. Which has sysadmin rights on the SQL box.
There is a difference between running as local system account and having sysadmin privileges.
ENsure to run MSSearch Service only with local system account.
And for MSSQLSErver service use an admin privileged account.
You need to restart the services if you make any changes.
I have both the builtin\administrators and Ntauthority\system account set up in SQL Server as sysadmins. I have tried running SQL under a domain account which is also a sysadmin but get the same results.
I think that MSSearch has somehow become corrupted i'm interested to here if you can uninstall and reinstall this.
It is a production server so I obiously dont want to much downtime.
Sorry forgot to mention, both services have been restarted several times.
http://support.microsoft.com/default...b;en-us;327217 refers that applying Sp3 (currently SP3a is only available) will upgrade the FUlltext catalogs by rebuilding them.
Thanks. I'll try this tonight and let you know if it helps.