Application synchronization failed for "Microsoft.Office.Server.Search.Administration.SearchService"
- Hi everyone,A domain controller have been recently demoted and then promoted for a new domain. On this server, Microsoft Office Sharepoint Server 2007 was installed Sharepoint. I've created the three missing groups: WSS_ Admin_WPG, WSS_RESTRICTED_WPG, WSS_WPG.I've also followed these instructions: http://support.microsoft.com/default.aspx/kb/934838 and thanks to this link: http://blog.tylerholmes.com/2008/03/restoring-shared-service-provider-admin.html, I was able to restore the SSP.Everything seems to work better but i'm getting this error in the Event Viewer:Event ID:6483:"Application synchronization failed for Microsoft.Office.Server.Search.Administration.SearchService.Reason: Column already has a DEFAULT bound to it.Could not create constraint. See previous errors.Techinal Support Details:System.Data.SqlClient.SqlException: Column already has a DEFAULT bound to it.Could not create constraint. See previous errors.at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()at Microsoft.Office.Server.Data.SqlSession.ExecuteScript(TextReader textReader, Int32 commandTimeout)at Microsoft.Office.Server.Data.SqlSession.ExecuteScript(String path, Int32 commandTimeout)at Microsoft.Office.Server.Data.SqlSession.ExecuteScript(String path)at Microsoft.Office.Server.Search.Administration.SearchSharedApplication.InstallSearchSchema()at Microsoft.Office.Server.Search.Administration.SearchSharedApplication.Install()at Microsoft.Office.Server.Search.Administration.SearchSharedApplication.Microsoft.Office.Server.Administration.ISqlRestore.OnSqlRestore()at Microsoft.Office.Server.Administration.SharedResourceProvider.SynchronizeApplications(SharedComponentSecurity sharedApplicationSecurity)For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. "And when I try to start the "Windows SharePoint Services Administrations" service, a warning is displayed: "The Window SharePoint Services Administration service on Local Computer started and then stopped. Some services stop automatically if they have no work to do ..." . And we have then an error in the event viewer: Event ID 0 Source: SPAdmin."Service cannot be started. System.ComponentModel.Win32Exception: The specified local group does not existat Microsoft.SharePoint.AdministrationOperation.Win32.SPNetApi32.NetLocalGroupGetMembers(String groupName)at Microsoft.SharePoint.AdministrationService.SPAdministrationService.RegisterSPAdministrationOperation()at Microsoft.SharePoint.AdministrationService.SPAdministrationService.OnStart(String[] args)at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)"Does someone have an idea about these errors ?Thanks,
Answers
Hi,
It seems that the SharePoint Search Service doesn’t work fine after SSP being restored.
This might be cause by some missing steps when you restore it.I suggest you follow the instructions from this official reference to backup and restore SSP then check the results.
Backup and restore SSPs (Office SharePoint Server 2007)
http://technet.microsoft.com/en-us/library/cc512095.aspxHope it can help.
Lily Wu- Marked As Answer byLily WuMSFT, ModeratorTuesday, December 01, 2009 1:01 AM
- Hi Lily,Thanks for the reply. I will try it.Regards,
- Marked As Answer byLily WuMSFT, ModeratorTuesday, December 01, 2009 1:01 AM
All Replies
Hi,
It seems that the SharePoint Search Service doesn’t work fine after SSP being restored.
This might be cause by some missing steps when you restore it.I suggest you follow the instructions from this official reference to backup and restore SSP then check the results.
Backup and restore SSPs (Office SharePoint Server 2007)
http://technet.microsoft.com/en-us/library/cc512095.aspxHope it can help.
Lily Wu- Marked As Answer byLily WuMSFT, ModeratorTuesday, December 01, 2009 1:01 AM
- Hi Lily,Thanks for the reply. I will try it.Regards,
- Marked As Answer byLily WuMSFT, ModeratorTuesday, December 01, 2009 1:01 AM
