Search Error

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

BartonFriedland at 2007-9-6 >

Getting the same Application Event, but for me it's stuck in the middle of Starting the Index server, so I can't even assign the Index server to the SSP (which has helped me in various situations before).

Event Type: Error
Event Source: Office Server Search
Event Category: Gatherer
User: N/A
Description:
Could not create a database session.

Context: Application '5ac793fa-b113-4150-b098-17470abdae22'

Details:
The database connection string is not available. (0xc0041228)

On the Services on Server page, it just continues to show Office SharePoint Server Search in the state of Starting.

On the intended Index server, there is also this Application Event:

Event Type: Information
Event Source: Office SharePoint Server Error Reporting
Event Category: None
Event ID: 5001
User: N/A
Description:
Bucket 12151763, bucket table 5, EventType ulsexception12, P1 owstimer.exe, P2 12.0.4518.1016, P3 45529fd9, P4 microsoft.office.server.search, P5 12.0.4518.0, P6 45439dcc, P7 2681, P8 136, P9 invalidoperationexception, P10 837q.

Data:
0000: 42 00 75 00 63 00 6b 00 B.u.c.k.
0008: 65 00 74 00 3a 00 20 00 e.t.:. .
0010: 31 00 32 00 31 00 35 00 1.2.1.5.
0018: 31 00 37 00 36 00 33 00 1.7.6.3.
0020: 0d 00 0a 00 42 00 75 00 ....B.u.
0028: 63 00 6b 00 65 00 74 00 c.k.e.t.
0030: 54 00 61 00 62 00 6c 00 T.a.b.l.
0038: 65 00 20 00 35 00 0d 00 e. .5...
0040: 0a 00 ..

JMLyle-mofo at 2007-9-6 >