Microsoft.SqlServer.Management.SqlIaaSAgent Install fails with "maximum message size quota for incoming messages (65536) has been exceeded"

Question

When attempting to install extension Microsoft.SqlServer.Management.SqlIaaSAgent v2.0.143.0 on our virtual machine we are seeing the following error

The maximum message size quota for incoming messages (65536) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element.

I've tried this on and off for months and end up with the same error

The detailed errors show provisioning succeeded on various tasks until this

    {
        "code": "ComponentStatus/Assessment Status/failed/54006",
        "level": "Error",
        "displayStatus": "Provisioning failed",
        "message": "{\"RunStatus\":\"Running\",\"StartTime\":\"2023-08-21T23:18:03.9997647+00:00\",\"AssessmentHistory\":[{\"CompletionStatus\":\"Failed\",\"StartTime\":\"2023-07-11T02:19:22.9570665+00:00\",\"EndTime\":\"2023-07-11T02:24:42.7583541+00:00\",\"ReportId\":null,\"ErrorMessage\":\"The maximum message size quota for incoming messages (65536) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element.;The maximum message size quota for incoming messages (65536) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element.\"},{\"CompletionStatus\":\"Failed\",\"StartTime\":\"2023-07-11T02:04:20.4363751+00:00\",\"EndTime\":\"2023-07-11T02:09:59.1781295+00:00\",\"ReportId\":null,\"ErrorMessage\":\"The maximum message size quota for incoming messages (65536) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element.;The maximum message size quota for incoming messages (65536) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element.\"}],\"NextScheduledTime\":null}"
    }

Answer 1

Hello Blair McClelland,

Thank you for contacting Community Form. We will try to assist you in best possible way.

As you mentioned SQL Extension is failing to install, please confirm and check below details:

1. Are you facing issue with any other extensions on this machine?
2. Have you checked the prerequisites-
   https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-agent-extension-manually-register-single-vm?view=azuresql&tabs=azure-portal#prerequisites
3. Is MaxReceivedMessageSize and MaxBufferSize same?
4. Is this extension working on any machine in your subscription?
5. Are these machines created using custom image or marketplace image?

Also, share the details about the solutions tried and roles installed on the machine so I can investigate further.

-Kanika