Call to HttpSendRequestSync failed for port 80 with status code 500 – MP replica


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;
GO

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.

 

One comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s