SharePoint 2010: Errors while creating AD Sync connection on User Profile Service Application

Hi all,

Taking advantage of August, I’m updating some SharePoint 2010 farms to SP2 (yes I know I was out of support), I didn’t have any complications during this upgrades, but I will post a problema that was stucking me for a while. After I updated the SharePoint Farm, it was not posible to start the User Profile Service sync connection, and when I tried to started it it throwed the following error in the Event Viewer:

Unable to process Create message

In the Application event log:
Source: Forefront Identity Manager
Event ID: 3
mscorlib: System.Runtime.InteropServices.COMException (0x80080005): Retrieving the COM class factory for remote component with CLSID {835BEE60-8731-4159-8BFF-941301D76D05} from machine WOLVERINE failed due to the following error: 80080005.
   at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)
   at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)
   at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)
   at System.Activator.CreateInstance(Type type, Boolean nonPublic)
   at Microsoft.ResourceManagement.SyncConfig.VerifyServerInterface()
   at Microsoft.ResourceManagement.SyncConfig.GetMAUtilityObject(String maType, String initializationString, String& errorMessage)
Source:  FIMSynchronizationServie
Event ID: 6324
The server encountered an unexpected error and stopped.
“BAIL: MMS(6812): sql.cpp(8490): 0x80231334 (The sql connection string has unsupported values.)
BAIL: MMS(6812): sql.cpp(8533): 0x80231334 (The sql connection string has unsupported values.)
BAIL: MMS(6812): server.cpp(260): 0x80231334 (The sql connection string has unsupported values.)
BAIL: MMS(6812): server.cpp(3860): 0x80231334 (The sql connection string has unsupported values.)
BAIL: MMS(6812): service.cpp(1539): 0x80231334 (The sql connection string has unsupported values.)
ERR: MMS(6812): service.cpp(988): Error creating com objects. Error code: -2145184972. This is retry number 0.

To solve this problem I’ve done the following:

1.Stop UPSS (User Profile Sync Service)
2.Make the following change on the App SharePoint Server
3.Click Start –> Run –> GPEdit.msc Computer Configuration Windows Security Settings Local policies Security Options “Network security: LDAP client signing requirements”, set the parameter value on “None”      (by default it will set to ‘Negotiate Signing’, details can be found on ‘Explain’ tab)
4.Run “gpupdate /force” without quotes on command prompt
5.Restart UPSS (User Profile Sync Service)

And then, it was able to start the User Profile Sync and start the profile importation
Hope it helps!
Advertisements