SharePoint Search Service Error – Could not access the Search service configuration database


Online project management, task software, and free collaboration workspace: AJAXWorkspace
AJAXWorkspace is a free online workspace that offers task tracking software, team collaboration, online calendar, document sharing, and file management for project management and teamwork.

I got error “Could not access the Search service configuration database” to start the search service after filling in the account and database info while seting up SharePoint (MOSS 2007) in a server farm. After googling, apparently SPSearch(or WSS) doesn’t like its server name to be a FQDN, instead, it prefers NetBIOS. To solve this, you have to change the FQDN name to a NetBIOS name in the SharePoint_Config database.  IMPORTANT!! Please do a database backup before proceed!!

Here is the solution I found:

Open your SQL Query Analyzer and execute this command. This command will replace the “NETBIOS” and “FQDN” string to your server settings.
use SharePoint_Config
UPDATE Objects Set Name=’NETBIOS’ WHERE Id=(SELECT Id FROM Objects WHERE Name=’FQDN’)