Procedure to move LocalDB to a SQL server is as following:

• Stop the Scout service:  
  • Task Manager -> Services -> ScoutServer -> Stop 
• Navigate to C:\Users\(user which installed Scout as localDB) 
  • Copy the .mdf and .ldf file from the directory somewhere else, e.g. Desktop
  • If necessary, turn off the following services to copy the files
    
  • Transfer the .mdf and .ldf files to the server which hosts the SQL database
  • With SQL Server Management Studio (SSMS) connect to the SQL database engine where the database will be attached, with sysadmin rights user 
  • In SSMS right-click on the 'Database' and then select 'Attach' 
    
  • Select the MDF File Location and click add
    
  • Local DB is visible and manageable in SSMS
    
  • Go to your new Windows Server, where Scout will be installed 
  • Make sure that the user who is performing the installation (service user with non-expiring password) has admin rights 

    • SQL database role
      On database level, for console-only users in standard environments, the database roles db_datareader and db_datawriter are sufficient.
      db_owner is needed, for example, for database activities related to updating to a new Scout version. The same applies for performing any configuration and maintenance activities on the database.

      The users must be mapped to the default schema dbo.

      For environments with SQL Server clusters, additional permissions such as VIEW SERVER STATE and VIEW ANY DEFINITION are required.

  • Install the same Scout Enterprise version, as you previously had (for e.g. 15.2409.1000) and during installation connect Scout Enterprise to the SQL database server and select the database you have attached previously (ScoutEnterpriseLocalDB) 
  • Make sure that the localDB Scout server is turned off 
  • If your new Scout server has a different IP than the previous one, make sure to adjust the DHCP or DNS settings of your network for the automatic registration of devices 
  • If you are not using automatic self registration of devices, you have to rediscover your devices in the new Scout server via the Discover option 
  • Make sure to adjust the firewall settings on the new server