I installed SP1 on a existing configuration manager installation (fresh install no CU installations).
Everything is fine, only the SMS_State_System component shows errors
Microsoft SQL Server reported SQL message 6522, severity 16: [42000][6522][Microsoft][SQL Server Native Client 11.0][SQL Server]A .NET Framework error occurred during execution of user-defined routine or aggregate "fnReadMDMPolicyCertValidationDuration": System.Data.SqlTypes.SqlTypeException: Two strings to be c
in the statesys.log i find the following error
*** [42000][6522][Microsoft][SQL Server Native Client 11.0][SQL Server]A .NET Framework error occurred during execution of user-defined routine or aggregate "fnReadMDMPolicyCertValidationDuration": ~~System.Data.SqlTypes.SqlTypeException: Two strings to be compared have different collation.~~System.Data.SqlTypes.SqlTypeException: ~~ at System.Data.SqlTypes.SqlString.StringCompare(SqlString x, SqlString y)~~ at System.Data.SqlTypes.SqlString.Compare(SqlString x, SqlString y, EComparison ecExpectedResult)~~ at Microsoft.SystemsManagementServer.SQLCLR.CryptoUtility.fnReadMDMPolicyCertValidationDuration(SqlString MessageText)~~. : sp_UpdateAPNSCertAlertVariable
Can someone help me or point me in the right direction to solve this problem?
best regards and thenk you in advance.
- Edited by Christian Forst 15 hours 21 minutes ago misspelled one word