How can I update the server IP in the database?

How can I update the server IP in the database?

Follow these steps to update the server IP in the database:

1) Execute <
AppManager_Home>\bin\troubleshooting\UpdateIP.bat file with the old and new hostname as arguments. 

For example, 

updateIp.bat  [mysql port]  [previous IpAddress]  [new IpAddress] [mysql password]

[mysql port]
            Mysql port used by applications manager. It is the value of the am.mysql.port (or am.db.port) entry mentioned in the AppManagerHome\conf\AMServer.properties file 
[previous Ip]           The previous or old ip address which needs to be changed. It is displayed in Applications Manager. This you can find by going to the Monitors details page of any services in the host.
[new Ip]                  The new ip address
[Password]              Password for connecting to MySQL. By default appmanager is the password.


2) After executing this, restart Applications Manager and check if the IPs are updated. 

Note: These steps will change the IP of the monitors. The display name of the monitors will not be changed. You can change this by going to Edit Monitor link for the individual monitors.

                  New to ADSelfService Plus?

                    • Related Articles

                    • Azure SQL Database - Troubleshooting - Add client IP to Azure firewall

                      "Connection to the database failed with error : Cannot open server <ServerName> requested by the login. Client with IP address <SomeIP> is not allowed to access the server.  To enable access, use the Windows Azure Management Portal or run ...
                    • Azure SQL Database - TCP/IP connection to the host <Azure SQL server> on port 1433 has failed

                      "Connection to the database failed with error : The TCP/IP connection to the host <Azure SQL server>, port 1433 has failed. Error: "Connection timed out: no further information. Verify the connection properties. Make sure that an instance of SQL ...
                    • Mail Server Monitor - Troubleshooting

                      Common Mail Server Monitor Errors and Troubleshooting Guide 1. Unknown Host Error Description: This error occurs when the mail client cannot resolve the hostname of the mail server to an IP address. The issue typically arises from DNS resolution ...
                    • Azure SQL Database - FAQ

                      1. Why have we removed the Diagnostic Settings dependency in Azure SQL Database monitor? Till APM v15240: Azure SQL Database was using Diagnostic Settings to perform data collection. Prerequisites had to be fulfilled to turn on Diagnostic Settings ...
                    • How do I update the server name in the database?

                      Here is how you can update the server name in the datatbase: 1) Execute <AppManager_Home>\bin\troubleshooting\updateHostName.bat file with the old and new hostname as arguments.  For example: updateHostName.bat  [mysql port]  [previous hostname]  ...