Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

WSS Search

  Asked By: Denny    Date: Oct 07    Category: Sharepoint    Views: 1162

We are having problems with the search in WSS. We aren't getting an error, it just returns no results. We are connecting to a SQL database. Everything else on the site seems to be working fine. We think it is some kind of permission at the SQL server, but have been unable to find it. Anyone have any suggestions for us.



9 Answers Found

Answer #1    Answered By: Anuj Lakhe     Answered On: Oct 07

Check to make sure that the full-text catalog on the <blah>_SITE
database you are using is both running and populated.

Answer #2    Answered By: Lee Dickerson     Answered On: Oct 07

Look in SQL Enterprise Manager under the content DB and make sure the index is
being created....

Answer #3    Answered By: Aditiya Kapale     Answered On: Oct 07

Can you elaborate as to which tables I'm looking for?

Answer #4    Answered By: Cristopher Gould     Answered On: Oct 07

OK, I found the following instructions to troubleshoot my search  issue:

1. Ensure SQL Server 2000 Full Text Search component is installed.
2. Ensure MSSearch service is running and set for "Auto Start".
3. Ensure MSSearch service is configured to run under "Local System"
- If MSSearch is not running as "Local System" account, ensure that
the account it is configured under has permissions in SQL Server and
database access to the WSS databases.
4. Check Application Log for errors of the MSSearch service.
5. Check SharePoint Central Admin to ensure "Enable Full Text Search"
is checked.
6. Reboot the SQL Server. Reboot the SharePoint Servers.
7. Rebuild Full Text Search indexes as follows:
a. Start Enterprise Manager on the SQL Server.
b. Navigate to the WSS database.
c. Select the "Full-text Catalogs" leaf.
d. Double click the catalog called "ix_STS_SERVERNAME_NUMBER" on the
right hand side.
e. Check if "Item Count" and "Catalog Size" is 0.
f. Close the window.
g. Right click the "Full-text Catalogs" leaf and click "Rebuild all
catalogs" in the context menu.
h. Answer "Yes" for the security prompt.
8. Reset the "Enable Full Text Search" box in SharePoint Central Admin
a. Uncheck the "Enable Full Text Search" box.
b. Click OK.
c. Check the "Enable Full Text Search" box.
d. Click OK.
9. Re-register DLL's by:
a. Execute 'regsvr32 "C:\Program Files\Common
Files\System\MSSearch\Bin\Query.dll" on each node of the SQL cluster.
b. Execute 'regsvr32 "C:\Program Files\Common
Files\System\MSSearch\Bin\Tquery.dll" on each node of the SQL cluster.
10. Run the following SQL commands from Query Analyzer on the SQL
a. EXEC sp_grantlogin [NT Authority\System]
b. EXEC sp_addsrvrolemember @loginame = [NT Authority\System],
@rolename = 'sysadmin'

It was during step 9A that I discovered that the path C:\PROGRAM FILES\COMMON FILES\SYSTEM\MSSEARCH did not exist. Any ideas why these files might not be present? Could this be the reason why this isn't working? I would think I would receive an error  in the WSS admin page indicating something was awry if these were direct dependencies.

Answer #5    Answered By: Selena Glenn     Answered On: Oct 07

Well, I guess you found the problem. Talk to your DBA (or look back if you
are the only admin). Full-Text Indexing is not installed if you did a
minimal install of SQL Server. (Or the install was botched).

Were you able to rebuild the indexes in step 7? Did the document count or
index size rise (above 0 docs or 1MB index size)?

Answer #6    Answered By: Jonathon Palmer     Answered On: Oct 07

We are just getting started with Sharepoint. We plan to take it slow
and start with WSS only. One of our concerns is the deficient search
capabilities in WSS (versus portal). Can anyone recommend a good 3rd
party search  tool to use? If you are currently using a 3rd party search
tool, I would like to know what pros and cons you have encountered.

Answer #7    Answered By: Aastha Patel     Answered On: Oct 07

CorasWorks has a search  web part that I believe is free. You might
try that one.

Answer #8    Answered By: Akshay Gupta     Answered On: Oct 07

I have a WSS installation where the search  was working  fine for all sites and
subsites. But after I migrated the entire site  collection to another server, the
search has been intermittent. It works at some site and not work at others. Is
there a way to configure search for a WSS installation? Anybody have any
recommendation on how I can start troubleshooting this?

Answer #9    Answered By: Trinity Scott     Answered On: Oct 07

In the content database  settings, un-associate your contentDB with the
Search Server. Give it a couple of minutes, then re-associate. Next, run
an 'stsadm.exe -o spsearch -action fullcrawlstart' on the search  server.

Didn't find what you were looking for? Find more on WSS Search Or get search suggestion and latest updates.