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)