Cannot start the WSS Search Service & Office SharePoint Search not working - Same SQL & WSS\MOSS Server

Cannot start the Windows SharePoint Services Search Service & Office SharePoint Search not working-Same SQL & WSS 3.0\MOSS 2007 Server

Running SQL and MOSS on the same server, I was unable to start the WSS Search Service and the Office SharePoint Search service was showing errors in the SSP Site.

Event Viewer Description:-

Event Type:Error

Event Source:Windows SharePoint Services 3 Search

Event Category:Gatherer

Event ID:10034

Description: Could not access the Search service configuration database.

Context: Application '8f7d4cbe-8cb1-4d32-b406-1737af554479'

Details:The filename or extension is too long.(0x800700ce)


Event Type:Error

Event Source:Office SharePoint Server

Event Category:Office Server Shared Services

Event ID:6482

Description:Application Server Administration job failed for service instance Microsoft.Office.Server.Search.Administration.SearchServiceInstance (9d344ee4-eacc-4460-8dc6-bb66bd5ab982).

Reason:The path is not of a legal form.

Techinal Support Details:

System.ArgumentException: The path is not of a legal form.

at Microsoft.Office.Server.Search.Administration.SearchApi.RunOnServer[T](CodeToRun`1 remoteCode, CodeToRun`1 localCode, Boolean useCurrentSecurityContext, Int32 versionIn)

at Microsoft.Office.Server.Search.Administration.SearchApi.AddApp(Role role)

atMicrosoft.Office.Server.Search.Administration.SearchServiceInstance.InstallGathererApplicationIf()

at Microsoft.Office.Server.Search.Administration.SearchServiceInstance.Synchronize()

atMicrosoft.Office.Server.Administration.ApplicationServerJob.ProvisionLocalSharedServiceInstances(Boolean isAdministrationServiceJob)

Root cause:-

If you are running SQL and WSS 3.0/MOSS 2007 on the same server,you will need to specify the Database Server, in the SharePoint Configuration Wizard as the NetBIOS name (Server01) and not the FQDN (Server01.Domain.com).Seems to be a bug in SharePoint as I always use the FQDN wherever possible.

Resolution:-

Disconnect from the SharePoint Farm (by running the SharePoint Configuration Wizard) and reconnect, this time using the NetBIOS name for the DB server. You will need to set the Indexer for any SSP’s you have created and restart some of the Services on the SharePoint Server but you should get back up and running.