User profile Services Prompt "Bail:mms (7116): Sql.cpp (8490): 0x80231334 (The SQL connection string has unsupported values.)" Solutions

2 Services for User Profile Service the Forefront Identity Manager service and the Forefront Identity Manager Synchronization Service cannot start the prompt as wrong Miss:

Execute the following PowerShell script:

Use the following command to obtain a UPS service instance to the current server site:

$UPSInstances = Get-spserviceinstance |? {$_. GetType (). ToString ()-eq "Microsoft.Office.Server.Administration.UserProfileServiceInstance"}

Use the following command to obtain an instance of the UPS service with a status exception:

$StuckUPSInstances = $UPSInstances |? {$_. Status-ne "Online"}

For example, the following command re-initializes/starts the UPS service instance:

$StuckUPSInstances | foreach-object-process {$_ | Start-spserviceinstance}

Wait a moment and you'll see the service restart.

User profile Services Prompt "Bail:mms (7116): Sql.cpp (8490): 0x80231334 (The SQL connection string has unsupported values.)" Solutions