Documentation forSolarWinds Platform

Update SolarWinds Platform products to use the new database

This topic applies to all SolarWinds Platform products.

After you have restored your SolarWinds Platform database backup file on the new server, you must update the database location for the SolarWinds Platform server to access the restored database on the new database server.

SolarWinds recommends that you use SQL Server Authentication with the sa login and password to ensure that Orion can always access the SolarWinds Platform database, even if it is hosted remotely on a separate server.

  1. Log in to your SolarWinds Platform server.
  2. Start the Configuration wizard in the SolarWinds Orion program folder.
  3. On Database Settings, specify your new database server in the SQL Server field.
  4. To use SQL authentication, select Switch user (Windows, Azure Active Directory or SQL Server Authentication), provide the SA account credentials, and click Next.
  5. Select Use an Existing Database, select or type the existing database name, and click Next.
  6. If you are prompted to use the existing database, click Yes.
  7. Select Create a New Account, and provide a New Account name.
    • Creating a new account ensures that Orion has required access to your migrated database.
    • The New Account must be a member of the securityadmin server role.
    • The sysadmin role and the sa user account are always members of securityadmin.
  8. Provide and confirm an account Password, and click Next.
  9. Click Finish to exit the Configuration Wizard.