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

  • 项目
  • 适用于:
    SharePoint Server 2013

症状

无法在 Microsoft SharePoint Server 2013 中启动用户配置文件同步服务。 服务显示“ 正在启动” 或“ 已停止”状态。 此外，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 社区。