Sharepoint2010 新建用户配置文件报错

管理中心的UserProfileService维护界面，点击“新建配置文件”，挂了：“无法加载用户配置文件”。

后台日志：

880i High System.Data.SqlClient.SqlException: Failed to load Msxmlsql.dll. 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning.....................................

 

从网上找到一个说法。

 

Root cause:

The issue happens due to the SQL installation order. When you Install SQL 2008 Express edition after SQL 2008 R2 installation, the "Msxmlsql.dll" file gets over written with the SQL 2008 Edition. This file is responsible of parsing XML and once its over written with the Express version, the issue start with any application.

Solution/Workaround:

The safest approach is to Uninstall the SQL 2008 Express edition.

 

我就是先装了Sqlserver 2008 R2，然后装了VS2010（这里面自带了坑爹的Sqlserver 2008 Express）。

我把Sqlserver 2008 Express卸载以后就OK了。