Home | Resellers | Contact

FAQ contents

 

LicenseWatch FAQ

Moving the Database to a Different Server

First step is to create a new empty LicenseWatch database on the new server. There are 2 possibilities:

  • Create a new empty LicenseWatch database by running the LicenseWatch setup program. Choose Custom Install and uncheck LicenseWatch website

OR

  • Copy the existing LicenseWatch database with data using SQL Server management tools

Second step is to change LicenseWatch configuration to point to the new database. This is done by changing a DSN string in different configuration files. If you use the recommended SQL Server Authentication the DSN string will have the following form:

Data Source=[server];Initial Catalog=[database];
User ID=[username];Password=[password]

You must replace the following:

  • [server]: The name of the SQL Server. If you use a MSDE instance installed by the LicenseWatch setup program on the local machine, then [server] should be [server host name]\LicenseWatchMSDE
  • [database]: Database name. Default is LicenseWatchPlatinum
  • [username]: User name, sa is recommended
  • [password]: Password. If password is blank, just write Password=

You must replace the DSN string in the following files:

  • C:\Program Files\LicenseWatchPlatinum\Web\LWAdmin\Web.config
  • C:\Program Files\LicenseWatchPlatinum\Web\LWClientRequestHandler\Web.config
  • C:\Program Files\LicenseWatchPlatinum\Services\LWClientPackageHandler\LWClientPackageHandler.exe.config
  • C:\Program Files\LicenseWatchPlatinum\Services\LWSMSClient\LWSMSClient.exe.config if the SMS Client is installed

In each configuration file will have you will find the DSN string under appSettings:

  <?xml version="1.0" encoding="utf-8" ?>
    <configuration>
      <appSettings>
        <add key="DSN" value="Password=;User ID=;Initial Catalog=;Data Source=;"/>       </appSettings>
    </configuration>

The LicenseWatch windows services; LW Client Package Handler and LW SMS Client (if installed), must be restarted before the new database connection settings takes effect for background jobs.