Search Error 10032: Could not create a database session. Context: Application {GUID} Details: The database connection string is not available
SharePoint 2007 Search on a specific WFE returned “Your search cannot be completed because of a service error. Try your search again or contact your administrator for more information.” while in other WFEs search worked perfectly. This happened after I stopped the search service on a specific server and started it on another server in the Farm.
Examined the event logs and found the error:
Could not create a database session. Context: Application {GUID} Details: The database connection string is not available
Fix:
Exported the registry key [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\12.0\Search\Applications\{GUID}] from the WFE where search works and imported to the problematic server.
Which was something like:
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\12.0\Search\Applications\19d466e6-f04b-40b5-b9fa-525791e7fb50\ResourceManager]
“Data”=”Server=SQLServerName;Database=SharedServices1_Search_DB;Trusted_Connection=yes;App=Windows SharePoint Services;Timeout=15”
“Search”=”Server=SQLServerName;Database=SharedServices1_DB;Trusted_Connection=yes;App=Windows SharePoint Services;Timeout=15”
and it worked like a charm!
Agreed, worked like a charm. I had just had to rebuild SharePoint Shared Services with MS following a corruption, and two replacement servers in the farm showd this error, and didn’t have the new search guid in the registry. Copied whole branch from a working WFE and people search sprang to life. THANKS.