Do you need to move Consignor to a new server and would you like to do it yourself? This tutorial will explain how to. However, we do not recommend moving Consignor yourself unless you have knowledge of setting up SQL servers.
Important note: When you have moved Consignor to a new computer /server, you can no longer use the old installation. If you do, shipment and package numbers will be reused which could result in penalties from carriers and lost or returned shipments.
Consider checking our system requirements here before getting started, to make sure you have the hardware needed. This guide is for installations of Consignor with the SQL database on the same machine.
Follow these steps to move Consignor to a new server:
- Step 1. Make a backup of your Consignor database
- Step 2. Install Microsoft SQL server
- Step 3. Install Consignor On-premises
- Checklist - things to remember after the move
- Trouble shooting
Step 1. Make a backup of your Consignor database
To move Consignor you need a new backup of the database. Make sure the backup is new to avoid reusing any shipment or package numbers.
- Stop any Import and Export setup running in your Consignor. Go to Setup, locate any Import Setup and Export Setup icons, open them and remove the check mark in Import Active and Export Active.
- Go to File > Backup and Shrink.
- Under Settings, set the Destination path and click Backup. It is a good idea to choose a network path that the new server has access to, so you easily can copy the file to the new server.
- The backup is complete when you see the text Backup.bpl completed in the bottom left-hand corner of the Consignor window.
- Move the backup file to the new machine. A database backup can only be restored from a local drive.
- Remember to note the Installation ID as you will need this for the new installation. The Installation ID can be found by choosing Help > About Consignor On-premises.
- Stop and deactivate the ConsignorServer service.
Step 2. Install Microsoft SQL server
First step on the new machine is to install Microsoft SQL Server.
You can download an installation package from Microsoft here. The express version can be downloaded for free.
If you have an older version of Windows, you may download Microsoft SQL Server 2012 from Consignor here. Note that this version is prepared for Consignor and assumes that you install a database named Consignor and have the SQL database and Consignor on the same machine.
We recommend using at least Microsoft SQL server 2012 or newer. Please note that .NET framework version 4 or newer is required to benefit from all features in Consignor.
Step 3. Install Consignor On-premises
Contact Customer Service for guidance.
Checklist - things to remember after the move
When you're done with the Consignor installation and moving the database, there are a few things to remember. Not all of the points below are relevant for all installations.
- Remember to stop the ConsignorServer service on the old server if you didn't do this in step 1.
- Activate Export and Import setup on the new server. Remember to change paths if relevant and check that there is access.
- Test your printer settings, try printing a test label and an A4 document.
- If the ConsignorServer service is running on a specific user, this user must have all the necessary rights.
- If you have remote Consignor Clients, make sure to enable the TCP/IP configuration for the Consignor instance in SQL Server Configuration Manager. This is needed in order for a remote Consignor Client to be able to connect to the SQL Server. The Named Pipes protocol is NOT needed.
This section will explain some of the most commonly known errors you may experience when moving Consignor to a new server. If you encounter any problems not described here, we recommend contacting Consignor Customer Service for support.
Problems with database backup
Making a database backup as described in step 1 fails.
Try to make the backup from SQL Management Studio instead. It is also possible to make a database backup from SQL Explorer which can be opened in Consignor by going to Tools > Advanced > SQL Explorer.
Error message when entering product key
The message "The product key has not been changed correctly" appears after entering the product key in Consignor:
Simply click OK and ignore this message. All you need to do is enable Consignor Portal when all is up and running. Go to Tools > Consignor Portal status and click Enable Consignor Portal.
Installation ID already in use
Consignor says that the Installation ID is already in use.
Your installation ID has not been moved correctly to the new installation. Try to perform Step 5. Move your installation ID again. If the warning persists, contact Consignor Customer Service who can help you fix the issue.
No data in Consignor Portal
If for some reason you have not been able to shut down the old Consignor completely after the database backup was made, or you have restored an older database, shipments on the old installation and on the new installation will have identical IDs in Consignor Portal's database and Portal upload will fail.
You can reset the shipment IDs - go to Tools > Options > Restricted and click Reset Shipment Global Unique Id.
Make sure that Consignor Portal is enabled. Go to Tools > Consignor Portal status and click Enable Consignor Portal.
SQL error on stack
Clicking on a stack in Outbox generates an SQL error
Run a database update
Other trouble shooting tips:
- Service user account: Some customers use a specific user account to run ConsignorServer service but forget setting this up on the new server. This could result in some processes not working because of lacking access rights. Often error messages do not reflect issues due to access rights so make sure the service user has the appropriate rights.
- SQL user rights: Make sure your SQL user has the correct access rights and you are running Mixed mode authentication.
- Uninstall old service: Uninstall the Consignor Server service on the old machine if the machine is still in use. We occasionally see customers who restarted the old machine and caused the old Consignor to restart, resulting in duplicate data/imports.