Search Error

When I search from my portal I get the following error message:

Your search cannot be completed because of a service error.

I've just installed and configure MOSS. Search indexing is working fine and the indexes are propagating to my query server just fine. Below is event log info:

Event Source: Office Server Search

Event Category: Gather

Event ID: 10032

Description: Could not create a database session

Details: The database connection string is not available.

I've tried for days to to resolve this problem. Any help would be much appreciated.

Regards,

Glenn Meyer

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.

We have just setup a new Sharepoint 2007 farm, with a single Sharepoint server and a dedicated SQL 2005 server. We too are getting several errors while crawling search contents. We crawl internal web sites and file shares which are quite huge, about 500GB and 3 million files. We get teh following errors while crawling, in some cases the Sharepoint server completely freezes when crawls are run. We cannot logon remotely or to teh console, but some services respond when the server freezes,

Event Type: Error
Event Source: Office Server Search
Event Category: Gatherer
Event ID: 10027
Date: 6/19/2007
Time: 7:58:13 AM
User: N/A
Computer: NJASPS01
Description:
Failed to update committed transaction in SQL, DocID is 1605321.

Context: Application 'SharedServices1', Catalog 'Portal_Content'

Details:
Unspecified error
(0x80004005)

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: 6/19/2007
Time: 7:57:32 AM
User: N/A
Computer: NJASPS01
Description:
A database error occurred.

Source: Microsoft OLE DB Provider for SQL Server
Code: 1205 occurred 17 time(s)
Description: Transaction (Process ID 95) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

Context: Application 'SharedServices1'

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: 6/20/2007
Time: 8:17:15 AM
User: N/A
Computer: NJASPS01
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.

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 ..