SharePoint Search Service Error - Could not access the Search service configuration database
October 4th, 2007 — ¥ong¥s
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’)
August 17th, 2008 at 9:21 pm
[...] Read the rest of this entry (moved to http://www.bronios.com) » Posted in SQL, SharePoint. [...]
February 25th, 2010 at 12:47 am
HI
I’M execute querry, (use SharePoint_Config
UPDATE Objects Set Name=’NETBIOS’ WHERE Id=(SELECT Id FROM Objects WHERE Name=’FQDN’)), but result is null.
the field name=’FQDN’ or name=’NETBIOS’, not present in Objects table