Note that this problem manifests for ConfigMgr 1511 +. My lab is running 1602
I’m setting up my lab for a presentation I’m running in a couple of weeks at a WMUG event. Basically I need to create a MP replica to demo some HA stuff.
When adding in MP replica role to my site system I kept getting the error ‘Call to HttpSendRequestSync failed for port 80 with status code 500, text: Internal Server Error’ in the MPControl.log file on the remote MP.
Checking the SQL replication I noticed that this was failing with an error:
‘CREATE ASSEMBLY for assembly ‘CryptoUtility’ failed because assembly ‘CryptoUtility’ is not authorized for PERMISSION_SET = UNSAFE. The assembly is authorized when either of the following is true: the database owner (DBO) has UNSAFE ASSEMBLY permission and the database has the TRUSTWORTHY database property on; or the assembly is signed with a certificate or an asymmetric key that has a corresponding login with UNSAFE ASSEMBLY permission. (Source: MSSQLServer, Error number: 10327).’
To resolve the problem I changed the MP replica DB (<sitecode>_REPL) to Trustworthy = True.
To do this run the following SQL command:
ALTER DATABASE <sitecode_REPL> SET TRUSTWORTHY ON;
As soon as the changes were made my status code 500 changed to the ‘Call to HttpSendRequestSync succeeded for port 80 with status code 200, text: OK’ message.