Move Foglight external backend database to another server (Migrate Foglight | Migrate Database) (4260799)

The database will move to another server, the database name and user/password will stay the same.

Which changes are required on the Foglight Management Server (FMS) and clients?

There are no changes required on the clients.

The Foglight Management Server configuration file $FGLHOME/config/server.config contains the database connection parameters.

If the existing database has been moved to a different host, only the server.database.host parameter needs to be updated to the new hostname.

server.database.host = "newhostname";

If the database name and/or port number were going to change, update server.database.port and server.database.name respectively.

server.database.port = "1433";
server.database.name = "foglight";

Note: For SQL Server, the value for server.database.port could be replaced with the named instance name (ie, FGL_Named_Instance instead of standard port "1433").

For the username and password update server.database.user and  server.database.password as required.

server.database.user = "foglight";
server.database.password = "q25f5a0c606fa55f9ee9dc65f698d8e6d";

Note: The password is set as an encrypted string - the above string is equal to the word 'foglight' - if the string is different, remember the password that was set and set that at the new database location or refer to solution How to reset the Foglight remote database user password if it has been forgotten? (4232181) to reset it.

For SQL Server, verify that the "foglight" database is set as the default database for the foglight user and that the 'foglight' user has the needed permissions on the foglight database.

In SQL Management studio navigate to "Security | Logins", right-click on the foglight user and select "Properties", verify that the default database for the foglight user is the foglight database and 'foglight' user has dbo permissions.

What steps are needed when moving Foglight to a different hardware? (4310144)

IP Address or hostname changed - what is needed to do on FMS? On the FglAM clients? (4228980)