Move the CurrentWare server to another computer with network SQL database

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.

#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)

  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.


Method 2 – Redirect Clients from the New CurrentWare Server

  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.

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.

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

    • Related Articles

    • How do I move the CurrentWare Server to another computer?

      #1 Back up your existing cwServer Database Before you migrate your server, back up your existing CurrentWare database. From the CurrentWare Web Console go to Tools > Database Backup Scheduler Click the Run Backup Now button at the bottom By Default ...
    • Redirect CurrentWare Clients to another CurrentWare Server

      For the redirect feature to work, the PCs must be turned on. PCs that are not online will not retroactively update when turned on at a later time. #1 – Redirect Clients From One Server to Another (Push) This option is mainly for moving existing ...
    • SQL Server Database and Password FAQS

      This page has some of the most frequently asked questions with how your SQL server interacts with CurrentWare. What is the default SA password for the CurrentWare SQL database? The CurrentWare installer is prepackaged with SQL Express. If you don’t ...
    • Remote CurrentWare Console is unable to connect to CurrentWare Server using SQL database

      If you have setup a Remote CurrentWare Console to be able to access your CurrentWare server running off a SQL database and are having connection issues. This is usually caused by either Firewall blocking or SQL Server settings. Solutions Turn OFF ...
    • Security & SQL Database Best Practices

      Security and Workflows Connection to the Web Console Starting with v8.0.1, the CurrentWare web console will have a preconfigured self-signed SSL certificate that is enabled by default. This will ensure that network communication to and from the ...