When I do a search in a sharepoint site, I get the following error :
Your search cannot be completed because of a service error. Try your search again or contact your administrator for more information.

When I check the app. log, the following is mentioned :

Event Type: Error
Event Source: Office Server Search
Event Category: Gatherer
Event ID: 10032
Date: 18/03/2007
Time: 17:36:16
User: N/A
Computer: SVRPOE
Could not create a database session.

Context: Application 'bdc68541-4efc-461e-838a-9aa19aafd291'

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

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

Can somebody please shine a light on this problem


Re: SharePoint - Search Could not create a database session

andrew woodward

Search is now part of the Shared Service Provider and also uses a Search SQL database for metadata and additional information. You need to check your search configuration in the ShareServices - via Central Administration.


Re: SharePoint - Search Could not create a database session


I had the same problem. The specific steps taken to resolve it were:

(1) Open Central Administration->SharedServices1 (my SSP).

(2) Click on Search Settings. An error will appear saying something about the search not being configured. It will offer a link to request appropriate account information. Click it.

(3) Configure the page presented and click OK.

(4) Wait a couple of minutes while the index migration occurs.

Everything should be back to normal!