Move the CurrentWare server to another computer with network SQL database

When moving your CurrentWare software to a new server/PC you need to make sure you do not have both consoles connecting to the same networked database. Here are the steps to take.

#1 Back up your existing cwServer Database

Before you migrate your server, back up your existing CurrentWare database.

  1. From the CurrentWare Web Console go to Tools > Database Backup Scheduler 
  2. Click the Run Backup Now button at the bottom
  3. By Default it will place the backup in the C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Backup folder located on the networked SQL server.

  1. Tools > Database Backup Scheduler > Enable database backup scheduler
  2. By Default it will place the backup in the C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Backup folder located on the networked SQL server.
  3. Select the Run Backup Now button
image-17

#2 Restore a clone of your existing cwServer Database

Before you install the new CurrentWare server we need to setup the database it will connect to, without having two databases connected at the same time. you will need Microsoft SQL Server Management Studio installed. Here is a direct link to the installer from the Microsoft Page.

  1. Run Microsoft SQL Server Management Studio
  2. Right-click on the Databases folder
  3. Select Restore Database
  4. Select the backup database you just created and want to restore.
  5. Under Destination change the name to CWNPSQLNEW.
  6. Press the OK button and you should now see two databases in the databases folder.

#3 Install the CurrentWare Server on the new computer

It is time to perform a fresh install of the Server and Console on the new machine. Download the latest CurrentWare setup file from this link.

If you running and older version of CurrentWare it is suggested to update the old location first, or install the same version onto the new location. Contact the support team to get any older install packages at support@currentware.com.

  1. Run the CurrentWare.exe setup file on the new server to proceed with the installation.
  2. When prompted for the SQL server information, make sure to use the newly restored location and database name.
    • Here you will change Server name to be the network location.
    • The Account and Password should be the same as your previous SQL Database.
    • Rename the SQL Database name to the restored Database name.

#4 Redirect the cwClients to the new cwServer

There are four methods to redirect the cwClients to the new cwServer. We kept the databases separated to make it easy to redirect active clients, and if there are clients currently offline, it allows you to re-access the existing/old CurrentWare server without interrupting the new one.

Method 1 – Redirect Clients from the Existing CurrentWare Server (Recommended)

Currently this feature is not available within the Web Console. You will need to open the CurrentWare Desktop Console to run a redirect. We are looking to add this feature into the Web Console in the next version update.

The desktop console can be found here: C:\Program Files (x86)\CurrentWare\cwConsole
Run the cwConsole.exe to open the CurrentWare Desktop Console and run the redirect.

  1. Launch the CurrentWare Desktop Console.
  2. Go to Tools > Redirect Clients.
  3. Select “Redirect CurrentWare Clients from this server to another server”.
  4. Enter server name and client password (default password is Admin).
  5. Choose which computers to redirect or “Select all computers”.

Note: This will only move currently “Connected” clients. Keeping the existing server separated allows us to attempt to push clients as they come online on the existing/old server.

redirect-currentware-client-to-the-new-server

Method 2 – Redirect Clients from the New CurrentWare Server

Currently this feature is not available within the Web Console. You will need to open the CurrentWare Desktop Console to run a redirect. We are looking to add this feature into the Web Console in the next version update.

The desktop console can be found here: C:\Program Files (x86)\CurrentWare\cwConsole
Run the cwConsole.exe to open the CurrentWare Desktop Console and run the redirect.

  1. Launch the CurrentWare Desktop Console.
  2. Go to Tools > Redirect Clients.
  3. Type in the Client password (default password is Admin) and select redirect all clients.
  4. After you press Ok, your clients will start to connect to the console within the next few seconds.
  5. Your connected cwClients will now be redirected to the new cwServer.
redirect-currentware-client-to-the-new-server

Method 3 – From the cwClients

If your clients are not connecting to the console even after you redirected them in the previous steps, you can try to manually connect them to the server.

  1. Go to the client workstation.
  2. Browse to C:\Windows\SysWOW64\wcsystck\.
  3. Double click on cwAgent.exe (not cwAgent64.exe).
  4. Put in the client password (default password is Admin).
  5. Click on Server Settings and modify the Server name to the IP address (or computer name) of the new cwServer.
cwclient-configuration-server-settings

Method 4 – Run a Command Line

This is the command line that allows you to reconfigure the CurrentWare Client to connect to another CurrentWare Server. The command line can be made into a batch file. It can be run from your remote control tools. It can be made into a log on script for your group policy.

In the following example, replace “Admin” with your CurrentWare Client password and swap the IP address with your CurrentWare Server.

On 64-bit client computers:

C:\Windows\SysWOW64\wcsystck\cwClient.exe -p Admin -ds 192.168.1.11

On 32-bit client computers:

C:\Windows\system32\wcsystck\cwClient.exe -p Admin -ds 192.168.1.11