The following videos will show you how
to test with a trial license key, help you decide which type of license to purchase,
show you how to activate your license key(s), and show you how to migrate an existing
license to a different server. In addition, if you purchase subscriptions at different
times, there is a video that will explain what it means to co-term licenses and
how the charges are calculated.
COZYROC offers you
the opportunity to fully test the components of interest before you pay for a license.
There are no time restrictions and the SSIS+ Suite you test with is exactly the
same as the SSIS+ Suite you will be using once you purchase a license. The only
restriction you’ll be working under is that you cannot automate the execution of
your packages without a license key.
After you’re satisfied
that our components are suitable for the projects you’re working on, then you’ll
want to test the automation of your package execution in an environment that mimics
your production environment as closely as possible. At this stage, you’ll be able
to test with
a free trial license key
that is good for 30
After 30 days, you’ll
need to purchase a license. If your server does not have Internet access,
will explain how to get your free
trial license key.
for an explanation of the types of licenses
you may purchase, their cost, and what is included with each type.
Once you purchase
a license, you will need to activate the license keys on the servers where you will
be scheduling and executing your packages. The SSIS+ Suite will need to be downloaded
and installed on the server(s) where the packages will be executed. If you are using
Data Flow Task Plus, you will also need to have SSDT installed on that server(s).
Be sure to
check the compatibility chart
to ensure the version
of SSDT you have installed is compatible with the version of the SSIS+ Suite you
When you download
and install (all one step) the SSIS+ Suite, it will also install the license application.
You can open the application by going to the Windows Start menu. Then, find the
COZYROC SSIS+ sub-menu. It is an application within the COZYROC SSIS+ menu item
that has the word “License” in its name.
describing how to get a license key when the server has Internet access, read
or watch this
. For instructions describing how to
get a license key when the server does
have Internet access (e.g.
there is a firewall), read
You only need to request the license
key once if you purchased a Perpetual license. The only reason you would ever need
to request the license key again is if you are transferring the license key to a
different server or you upgrade SQL Server on the server.
If you get an error when you attempt
to retrieve or update your license key, check the Knowledge Base articles for assistance.
Retrieving Your Purchased License Key
- How to retrieve the license key via the License Application
- How to get my license key when my server sits behind a firewall and I'm unable to contact the COZYROC license server.
- When my server sits behind a firewall, which ports should I open for COZYROC License Server?
SQL Job Agent and Command Line
Error Messages related to getting your license
If you purchased
a subscription, you will need to update your license keys each year after your subscription
renews. Renewals happen automatically if you purchased the subscription via PayPal.
If you used the Purchase Order/Invoice process, you will receive an email reminder
to renew each year before your subscription expires.
If you use PayPal
to purchase your licenses, we highly recommend that you use a company PayPal account
and a company credit card. Our subscription customers often have trouble with their
renewals when personal accounts were used by former employees who are no longer
with the company. It can get complicated so sort things out
your PayPal account before your license
The same account
that was used for the original purchase will be used for renewals. The subscription
is actually managed by PayPal, not COZYROC. We cannot cancel your subscription or
modify it in any way. We also cannot force a renewal. PayPal tries to charge the
credit card 3 times and then it gives up and your license will expire.
You must be able
to log into the account and ensure that the credit card associated with the
is valid and up-to-date. It is not sufficient
to just update the credit card associated with the account. A specific credit card
is associated with the
and you must be sure that
this card will work for the renewal fee.
If you’ve watched the video about the different types of
licenses, then you know that you get two license keys for each subscription
purchased. You will use the same licensee identifier to get all the license
keys. Some customers get stumped because they believe that they need a different
identifier for each license key.
Be aware that it is up to you
to keep track of which servers you have installed license keys on. COZYROC only
has a record of the licensee identifier and the machine identifiers associated
with the license keys installed. Unless you can determine the specific server
from that information (not likely), we will not be able to help you.
Also, be sure to keep a backup of
the License.dat file from every server on which you install a license key. You
will need it to reset your license record when you want to free up a slot so
that you can use it on a different server. Some customers decommission a server
and then cannot get the License.dat file, which is why we highly recommend that
you save a backup copy of the License.dat file from every server where you have
ever acquired a license key.
Transferring a License Key
: If you want to transfer
a license key or free up a license key that is no longer being used, you can go
page to reset your license record. You will need to know your licensee identifier
and the email address associated with your account in order to use the form. Also,
you will need to upload the License.dat file from the decommissioned machine in
order to reset your record and free up the license key slot that was being used
by the decommissioned machine. See
Upgrading SQL Server
If you upgrade SQL Server on a server where you have SSIS+ installed, then
you will need to update your SSIS+ license key by clicking on the Update button
in the License application.
Moving a License
Removing and Resetting a License
After a SQL Server Upgrade
Active-Passive Cluster Configuration
In an active-active
or active-passive cluster configuration, both nodes are required to be licensed.
However, in an active-passive cluster configuration, there is no additional
cost to license the passive node, but both nodes do require a License Key. This applies regardless of whether you purchased the Ultimate Subscription or the Perpetual License. In either case, you can request a free extra license key for the passive node.
the License Key for the passive node is the same process as the active node.
However, you will need to create a
additional slots for the passive node. When creating the ticket, make
sure you select the SSIS Plus Billing and Subscriptions for the department and
include your Licensee Identifier(e.g., S-3WB79433GE935263E).
If your environment is restricted
such that each element of the registry is disabled unless it is specifically
enabled, then you will need to manually enable certain registry keys so that
SSIS+ can run on your server. The following tables provide the information you
will need so that you can enable the necessary keys on your server. The first
table provides registry keys that are created and used by COZYROC’s SSIS+. The
second table provides registry keys that are created by the SQL Server installation
and used by SSIS+.