无法启动用户配置文件同步服务

症状

在 2013 年 3 月,无法启动用户配置文件Microsoft SharePoint Server服务。 服务显示"正在启动" "已停止 "状态。 此外,ULS 日志中还记录了以下错误条目:

OWSTIMER.EXE (0x2B80) 0x3370 SharePoint Portal Server User Profiles g144 Unexpected Failed to set the new Service Broker on database <SyncDB> on server <ServerName>. Exception: The operation cannot be performed on database <SyncDB> because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group.  ALTER DATABASE statement failed.  ALTER DATABASE statement failed.    
OWSTIMER.EXE (0x2B80) 0x3370 SharePoint Portal Server User Profiles 9sip High UserProfileApplication.SynchronizeMIIS: Failed to configure MIIS post database, will attempt during next rerun. Exception: System.Data.SqlClient.SqlException (0x80131904): The operation cannot be performed on database <SyncDB> because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group.  ALTER DATABASE statement failed.  ALTER DATABASE statement failed.       
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)       
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)       
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)       
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)       
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)       
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()       
at Microsoft.Office.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand command)       
at Microsoft.Office.Server.Administration.SynchronizationDatabase.EnableServiceBroker()  
at Microsoft.Office.Server.Administration.UserProfileApplication.SetupSynchronizationService(ProfileSynchronizationServiceInstance profileSyncInstance)    
ClientConnectionId:<Id>  Error Number:1468,State:1,Class:16.    
OWSTIMER.EXE (0x2B80) 0x3370 SharePoint Portal Server User Profiles 9i1u Medium UserProfileApplication.SynchronizeMIIS: End setup for 'User Profile Service Application'.        

原因

如果同步数据库涉及数据库镜像会话或可用性组,则会发生此问题。

解决方案

若要解决此问题,请按照以下步骤操作:

  1. 从 <SyncDB> 数据库镜像会话或可用性组中删除同步数据库。
  2. 停止用户配置文件同步服务。
  3. 重新启动用户配置文件同步服务。
  4. 将 <SyncDB> 同步数据库还原到可用性组。

更多信息

仍然需要帮助? 请转到 SharePoint 社区