Overview

You are moving your EndpointSecurity installation to a new server and want to continue using your old SQL Database. When you use the import/export configuration tool, you receive an error stating that "The database settings were not imported because the Microsoft SQL Server is not reachable."

You require guidance on the proper steps to finalize this migration and address this error.

Solution

When migrating your EndPointSecurity, the import/export configuration tool only assists with moving the configuration, but not the underlying SQL Database. You can reference the steps below to guide you through the steps to move and then reconfigure your existing database.

1. Move your Database
   1. Copying your SQL database can be accomplished in several ways. Microsoft details several methods within Copy Databases to Other Servers that you can reference.
   2. Note: Management of your SQL database is outside of the scope of GFI Support. Please consult your Database Admin for assistance with this move.
2. Update the Database Backend
   1. Open your EndPointSecurity Management Console.
   2. Select Configuration > Options from the top navigation.
      
      ​​
      
      
   3. Select Configure > Database Backend.
   4. From the right pane, click Change database backend.
      
      ​
      
      
   5. Select the SQL Server you want to use from the Server drop-down menu.
   6. ​Specify the name of the database in the Database text box.
   7. Select the authentication mode and specify the login credentials, if necessary.
   8. Click Apply and OK.

Testing

After migrating and setting the database connection, re-run your import/export configuration tool and verify that this correctly imports the database settings.