Hi All,
Our CMG certificate has expired and trying to update it with new certificate issued using our local CA. When i try to apply the new certificate I'm getting the following error below. I have restarted the SCCM server and the SQL Box and and also tried stopping the CMG service in order to apply the new certificate. I have logged into Azure and uploaded the new certificate in the cloud Service (Classic) however that has not reflected back in the console.
Any help will be much appreciated.
"The SMS Provider reported an error:
ConfigMgr Error Object:
instance of SMS_ExtendedStatus
{
CauseInfo = "";
Description = "SQL command failed: ";
ErrorCode = 2168786178;
File = "..\\sspazureservice.cpp";
Line = 442;
ObjectInfo = "Please check SMS Provider log file for details of the SQL errors";
Operation = "PutInstance";
ParameterInfo = "";
ProviderName = "ExtnProv";
SQLMessage = "[23000][547][Microsoft][SQL Server Native Client 11.0][SQL Server]The UPDATE statement conflicted with the REFERENCE constraint \"Proxy_Settings_Azure_Service_FK\". The conflict occurred in database \"CM_XXX\", table \"dbo.Proxy_Settings\", column 'ProxyServerName'.";
SQLSeverity = 16;
SQLStatus = 547;
StatusCode = 2147749889;
};
Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryException
The SMS Provider reported an error.
Stack Trace:
at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlResultObject.Put(ReportProgress progressReport)
at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlResultObject.Put()
at Microsoft.ConfigurationManagement.AdminConsole.SmsDialogData.Put(Boolean retainLock)
at Microsoft.ConfigurationManagement.AdminConsole.DialogFramework.Forms.SmsPropertySheet.Put(ActionTrigger trigger)
System.Management.ManagementException
Generic failure
Stack Trace:
at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlResultObject.Put(ReportProgress progressReport)
at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlResultObject.Put()
at Microsoft.ConfigurationManagement.AdminConsole.SmsDialogData.Put(Boolean retainLock)
at Microsoft.ConfigurationManagement.AdminConsole.DialogFramework.Forms.SmsPropertySheet.Put(ActionTrigger trigger)
SMSProv.log
][1]