Agents not communicating to SolarWinds Platform Server using NAT address

When NAT is configured on the SolarWinds Platform server, you may find that agents are communicating with the SolarWinds Platform server private address and not the public address after translation. 
This results in SolarWinds Platform agents showing as down on the SolarWinds Platform web console. 

Agent settings get replaced with SolarWinds Platform server's private IP address every time agent services get restarted, causing the agent to fail to connect to SolarWinds Platform server

1. Connect to your SolarWinds Server, Go to Start > All Program > SolarWinds Platform > Database Manager.
2. Select Add Orion Server > Expand the database > open any table in your database (ex: Right click on table - choose Query table).
3. Remove the default query, paste the SQL query below then click on Execute Query:

Note: Replace x.x.x.x with the SolarWinds Platform server's public IP address

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

INSERT INTO [dbo].[AgentManagement_PredefinedConnectionSets] (ConnectionSetid,HostnameOrIP, Port, Priority) VALUES (1, 'x.x.x.x', <Port>, 1000)

Note: The following changes will disable automatic IP address updates to the SolarWinds Platform.  If the IP address needs to be changed, it will need to be manually changed using the script above.

4. Redeploy affected agents
   1. Log in to the SolarWinds Platform Web Console.
   2. Navigate to Settings > All Settings > Manage Agents.
   3. Select the agents with issues, and select More Actions > Retry Agent Installation.
5. Verify the SolarWinds.Agent.Service.exe.cfg (C:\Program Files (x86)\SolarWinds\Agent) and confirm that IP Addresses and hosts are listed:
6. Confirm if agents are up and running after reinstallation.