UserProfileApplication.SynchronizeMIIS:无法配置MIIS发布数据库 [英] UserProfileApplication.SynchronizeMIIS: Failed to configure MIIS post database

问题描述

大家好，

问候，

我在我的客户SharePoint 2013环境中遇到此错误."UserProfileApplication.SynchronizeMIIS:无法配置MIIS发布数据库".

I am facing this error at one of my customer SharePoint 2013 environment. "UserProfileApplication.SynchronizeMIIS: Failed to configure MIIS post database".

场景:

我们正在尝试运行用户配置文件同步服务，但是每次运行5分钟后 开始状态，最后以停止.

We are trying to run User Profile Synchronization service, but every time after 5 mins in starting status, it ended up with stopped .

环境设置:

2 WFE

1个APP

1 SQL 2012

1 SQL 2012

以前我们有SQL Server 2008 R2，并且遇到相同的错误，为了解决此问题，我们将SQL Server从2008 R2迁移到2012.

Previously we have SQL Server 2008 R2, and we were getting the same error, In order to get over to this problem, we migrate the SQL Server from 2008 R2 to 2012.

我们遍历了每个博客/论坛帖子，并尝试根据建议的步骤进行纠正，但没有用.

We have gone through each and every blog / forum post and try to rectify based on the recommended steps, but of no use.

以下文章链接陈述了四种可能的原因

The following article link states four Possible causes

可能的原因1:这是由于
的权限不足 同步数据库(不是配置数据库！)上的 SharePoint服务器场帐户.您需要
使用默认模式将服务器场帐户作为DBO添加到Sync DB用户
DBO，然后重新启动UPS.

Possible Cause 1: This is due to insufficient privileges for the
SharePoint Farm Account on the Sync DB (not the Config DB!). You need to
add the farm account to the Sync DB users as DBO with a default schema
of DBO and then start UPS again.

我们已经验证了SharePoint服务器场帐户是DBO，并且默认模式为DBO.

We have verified that  SharePoint Farm Account is DBO with default schema of DBO.

可能的原因2:错误
已安装的先决条件，即SQL Server Native Client 2012/2014为
已安装，而要求是具有SQL 2008/2008 Sp1.
此处的详细信息: http://technet.microsoft.com /en-us/library/cc262485.aspx#reqOtherCap

Possible Cause 2: Incorrect
Pre-requisites installed , i.e SQL server Native Client 2012 /2014 is
installed , while the Requirement is to have a SQL 2008 /2008 Sp1 .
Details here : http://technet.microsoft.com/en-us/library/cc262485.aspx#reqOtherCap

我们已经验证，在所有SharePoint框中都安装了2008 R2本机客户端

We have verified that on all the SharePoint boxes, 2008 R2 native client is installed

可能
原因3:如果您使用SQL Server 2014托管同步数据库或移动了
数据库到SQL 2014(Sharepoint 2013)，则存在一个已知问题
&您需要将Sharepoint 2013更新到2014年4月的CU或更高版本，
https://support.microsoft.com/en-us/kb/2760265

Possible
Cause 3: If you use SQL server 2014 to host the Sync DB or Moved your
Databases to SQL 2014 ( Sharepoint 2013 ) , then there is a known issues
& you need to Update to April 2014 CU or above for Sharepoint 2013 ,
https://support.microsoft.com/en-us/kb/2760265

 我们有SQL Server 2012，而不是SQL Server 2014

  We have SQL Server 2012, not SQL Server 2014

Shakir Majeed Khan，MCITP(SharePoint 2010)，MCPD(SharePoint 2010)

Shakir Majeed Khan, MCITP (SharePoint 2010), MCPD(SharePoint 2010)

推荐答案

以下是更多信息

Following are more information

可能
原因4:与SQL Server的连接性问题，例如Wrong Alias.开始
->运行-> Cliconfg检查&配置别名

Possible
Cause 4: Connectivity issues to SQL server , like Wrong Alias . Start
-->Run-->Cliconfg to check & configure aliases

正如我所提到的，我们已将数据库从2008 R2迁移到2012，我们已经完成了SQL别名的输入，以便与SQL Server连接.

As I have mentioned that we have migrated the Database from 2008 R2 to 2012, we have done entry into the SQL Alias in order to connect with SQL Server.

以前是命名实例，现在检查是否将实例设置为默认实例会有所帮助，因此我们将其设置为默认实例.我跟着 SQL Alias 帖子和其他博客帖子，以便进行SQL别名处理.但同样没有用.

Previously it was with named instance, now to check that if we make the instance as default that would help, so we make that as default instance. I have followed SQL Alias post and other blog post in order to do SQL Aliasing. But again its of no use.

可能的原因4:在创建SharePoint服务器场时使用SQL Server的FDQN.

我们的环境使用SQL Server的FQDN.

Our Environment used FQDN of SQL Server.

按照我们已经完成的步骤

Following steps we have already done with

• 删除UPA并重新创建
• 我发现，SQL和SharePoint框上的本机客户端是不同的，在SQL上它的sqlncli11.dll是SQL Server 2012，而在SharePoint框上是sqlncli10.dll.因此，我在SharePoint框上安装了SQL 2012本机客户端，而没有删除 SQL 2008 r2本机客户端，但没有用. http://www.harbar.net/articles/sp2010ups2.aspx#ups4

• Deleting the UPA and created again
• I found out that the native client on SQL and SharePoint boxes are different, on SQL its sqlncli11.dll as this is SQL Server 2012 and on the SharePoint Boxes it is sqlncli10.dll. So I install the SQL 2012 native client on SharePoint boxes, without removing the SQL 2008 r2 native client, but no use. http://blogs.technet.com/b/sajiths/archive/2014/04/12/user-profile-synchronization-service-stuck-in-39-starting-39-state-sharepoint2013.aspx , its mentioned in the comments
• Restarted the servers.
• Done this changes on the server hosting UPS http://www.harbar.net/articles/sp2010ups2.aspx#ups4

请让我知道您是否还有其他事情可能对解决此问题有所帮助.

Do let me know if you know any thing else which might be helpful to resolve this issue. 

这篇关于UserProfileApplication.SynchronizeMIIS:无法配置MIIS发布数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！