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.
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.
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 ...
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] ...
Error message while performing database backup of Applications Manager
While performing a database backup operation of Applications Manager build with Pgsql backend, you may encounter the following error, especially when your database size has grown bigger with a large number of tables. pg_dump: WARNING: out of shared ...