AX 2012: AOS connections to SQL failing, Event ID 4231

Add comments

Author John Boehm

Microsoft Certified Technology Specialist
Senior Information Systems Consultant-Dynamics AX More ...

Recently we have had two customers that received the following error message on their AOS servers running Windows Server 2016:

A request to allocate an ephemeral port number from the global TCP port space has failed due to all such ports being in use.

This is the result of the AOS running out of available TCP ports to use for communication with the network.

You can resolve this issue by adding the following entries to the AOS registry in HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters:

MaxUserPort REG_DWORD: 0000fffe (655534)

TcpMaxDataRetransmissions REG_DWORD: 00000005 (5)

TcpNumConnections REG_DWORD: 00fffffe (16777214)

TcpTimedWaitDelay REG_DWORD: 0000001e (30)

Once these registry entries have been created, reboot the AOS.

Author John Boehm

Microsoft Certified Technology Specialist
Senior Information Systems Consultant-Dynamics AX More ...


Microsoft's D365 business software offerings are robust ERP and Lean manufacturing enablers for disruptive environments. The latest release, Dynamics 365 For Finance and Operations, combines the powerful planning and execution features required of comprehensive Manufacturing and Distribution installations, and is available in both Cloud and On-Premises deployment models. Contact Agility Business Solutions, Inc. to learn more.

0 response s to “AX 2012: AOS connections to SQL failing, Event ID 4231 ”

Leave a Reply

Leave this field empty:

Powered by Mango Blog. Design and Icons by N.Design Studio