RE: Search Error in MOSS 2007

Tech-Archive recommends: Speed Up your PC by fixing your registry



The content access account appears to have the access rights in that an index
is being created and the UI reports several thousand items in that index.

The password has definitely not expired.

The service account is a local administrator on the machine, so should have
the rights to run common jobs.

The issue appears not to be the generation of the search index, but the
connection of the SharePoint UI to the search service.
--
Barton Friedland
Luminous Group
www.luminousgroup.net


"Sundar Narasiman" wrote:

Barton Friedland,

Did you check the following
1. Whether you content access account has enough rights to index & crawl the
content source
2. Whether the password for the SERVICE ACCOUNT is not expired or not
3. Whether SERVICE ACCOUNT has enough privileges to run your common jobs
like Timer, Search, Notification etc.

--
Thanks & Regards,
Sundar Narasiman, MCAD
Blog: http://dotnetbuzz.spaces.live.com/



"Barton Friedland" wrote:

I have set up several farms and not had this problem, however, on one
deployment, I am seeing something like this as well.



The crawl logs show that content is being crawled, however, whenever a user
searches for anything through the SharePoint UI, they get



"Your search cannot be completed because of a service error. Try your search
again or contact your administrator for more information"



Review of the logs show that no errors are generated at the time the user
searches on the server, however, there are some errors that show up in the
log that are similar to the above:



Event Type: Error
Event Source: Office Server Search
Event Category: Gatherer
Event ID: 10036
Date: 4/3/2007
Time: 6:01:53 AM
User: N/A
Computer: XXXX
Description:
A database error occurred.

Source: Microsoft OLE DB Provider for SQL Server
Code: 17 occurred 4097 time(s)
Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not
exist or access denied.

Context: Application '1ec2aec6-f2b1-4d97-9087-f9d9e82315ad'

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.




Event Type: Error
Event Source: Office Server Search
Event Category: Gatherer
Event ID: 10036
Date: 4/3/2007
Time: 12:35:28 PM
User: N/A
Computer: XXXX
Description:
A database error occurred.

Source: Microsoft OLE DB Provider for SQL Server
Code: 11 occurred 1 time(s)
Description: [DBNETLIB][ConnectionWrite (send()).]General network error.
Check your network documentation.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.




Event Type: Error
Event Source: Office Server Search
Event Category: Gatherer
Event ID: 10036
Date: 4/4/2007
Time: 3:00:58 AM
User: N/A
Computer: XXXX
Description:
A database error occurred.

Source: Microsoft OLE DB Provider for SQL Server
Code: 18452 occurred 1 time(s)
Description: Login failed for user ''. The user is not associated with a
trusted SQL Server connection.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.


Any troubleshooting steps that will help to identify how to solve this issue
would be greatly appreciated.



Thanks,



--
Barton Friedland
Luminous Group
www.luminousgroup.net
.



Relevant Pages

  • Re: HELP Please: Can crawl portal but not non_portal content
    ... I deleted the default content access account from the portal and added it ... > restarted the SQL and SPS servers several times in the correct order SQL ... The default portal content source crawls ...
    (microsoft.public.sharepoint.portalserver)
  • RE: Search Error in MOSS 2007
    ... Whether you content access account has enough rights to index & crawl the ... Event Source: Office Server Search ... Microsoft OLE DB Provider for SQL Server ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Permissions needed for installation files
    ... access account has access to to that location. ... If you are having problems with legacy client then set this server location ... on user network access account has access to to that location (Possibly try ...
    (microsoft.public.sms.swdist)
  • Re: HELP Please: Can crawl portal but not non_portal content
    ... server is usually the result of the proxy settings. ... If using a proxy make sure you have entries in the By Pass list for: ... I've seen problems when the CentralAdminAppPool identity account is not the ... > Check that the Default Content Access Account in SharePoint Central ...
    (microsoft.public.sharepoint.portalserver)