Unicon - Scout - Moving localDB to a new Scout server

book

Article ID: CTX695975

calendar_today

Updated On:

Description

Procedure to move LocalDB to a new Scout server is as following:

  1. Install Scout Enterprise on the new server(you can download the latest Scout version from myelux.com) 
  2. Install SSMS or sqlcmd on the same server:
  3. Stop the Scout service:
    • Task Manager -> Services -> ScoutServer -> Stop
  4. Copy your .mdf and .ldf file to C:\Users {user}
    • If need stop also these two Processes in order to be able to replace the database files:
      image.png
  5. Log in to SSMS or sqlcmd:
    • (localdb)\ScoutEnterpriseManagementSuite
      image.png
  6. Add a user for the instance (you can also use the username from old server), assign it to ScoutEnterpriseLocalDB and give it the db_owner role:
    image.png
  7. Replace the credential user in eluxd.ini that you created earlier:
    image.png
  8. Do the same in the registry:
    • Computer\HKEY_CURRENT_USER\Software\Unicon\Scout\Database
      image.png
  9. Start the Scout service and the two Processes
  10. Open the Scout Database Connection Editor and change on both tabs(Console and Server) following:
    • Type -> Microsoft SQL - Server
    • Server -> (localdb)\.\ScoutEnterpriseManagementSuite_Shared
    • Database -> ScoutEnterpriseLocalDB
      image.png
  11. Check connection

Issue/Introduction

This article shows the correct procedure of moving LocalDB to a new Scout server.