Licensing

Licensing

Overview 

On this page, you will find everything you need to know about COZYROC SSIS+ licensing, including when you need a license and when you do not need a license. If you are new to COZYROC, there are videos and articles which can help you with every step such as choosing the type of license to purchase, activating your license keys, how to handle subscription renewals and what you need to keep track of in-house. If you’ve been using COZYROC’s SSIS+ for a while and need a refresher on renewals or want to migrate a license key to another server, you’ve come to the right place for that, too. 

Tutorial Videos

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.

  1. Licensing Model Explained
  2. Getting a 30-day Trial License Key
  3. Activating a License Key on a Server with Internet access
  4. Activating a License Key on a Server without Internet access
  5. Migrating a License Key to a different Server
  6. Co-Terming License Subscriptions  

Testing and Developing from within Visual Studio

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.  

Knowledge Base Articles
  1. Can I test packages using SSIS+ components without buying a license?

Testing with a Free Trial 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 days. 

After 30 days, you’ll need to purchase a license. If your server does not have Internet access, this article will explain how to get your free trial license key.

Knowledge Base Articles
  1. Are free licenses provided for demo or test servers?
  2. How to install a TRIAL license key for a 30-day free trial
  3. How to get a 30 day TRIAL key for free when the server is behind a firewall.
  4. After installation, I cannot find the COZYROC License Application.
  5. How To change the permissions on the License file from inherited to explicit 
  6. Why is my License Expiration date immediately expired when I enter the 30-day TRIAL key?

Purchasing and Activating Licenses for Production

Watch this video 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 have installed.

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.

For instructions describing how to get a license key when the server has Internet access, read this article or watch this video . For instructions describing how to get a license key when the server does not have Internet access (e.g. there is a firewall), read this article  or watch this video .

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.

Knowledge Base Articles

Error Messages related to getting your license     

Considerations for Subscriptions

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 and fix your PayPal account before your license expires.

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 subscription 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 subscription and you must be sure that this card will work for the renewal fee.

Knowledge Base Articles 
  1. How long is the grace period after the subscription has expired? 

How to Activate License Keys on Multiple Servers

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.

Housekeeping 

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.

License Customer Form 

The License Customer Form will allow you to do the following:
  1. Reset License
  2. View Registered machines
  3. View Update history
Knowledge Base Articles
  1. How to use the License Customer Form.

Making Changes to Your Environment

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 to the License Customer 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 this article for instructions. 

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.

Knowledge Base Articles

Moving a License  

  1. How to migrate your COZYROC SSIS+ license to a new server

Removing and Resetting a License 

  1. How can I remove an activation from my license after exceeding the maximum number of licenses? 
  2. How to reset your License record
  3. Do you have a list of machines that are licensed/registered against our subscription/Licensee Identifier?  
  4. How do I retrieve my license.dat file after it has been deleted?

After a SQL Server Upgrade

  1. Error Message: CozyRoc component not licensed 
  2. Why is my license key no longer valid after performing an upgrade of SQL Server?  

Disaster Recovery, Cluster and Passive Nodes   

Licensing: 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.

Deploying the License Key for the passive node is the same process as the active node.  However, you will need to create a ticket via the COZYROC Help Center requesting 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).

Knowledge Base Articles
  1. What is the license cost for this scenario with a Disaster Recovery Server?
  2. How many licenses do I need to purchase for a SQL Server running in a cluster configuration?
  3. Is a License Key required on the passive node 

Registry keys 

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+.

Knowledge Base Articles
  1. Registry keys used by the COZYROC SSIS+ Library 

    • Related Articles

    • Error Message: License: 'License.dat' file not found.

      Action: When executing a package from SQL Server Agent job or when opening the COZYROC License Manager the following error was encountered: Error Message: License.dat file not found. Solution:           There are two possible solutions: The error ...
    • How to retrieve the license key via the License Application

      As part of the COZYROC SSIS+ Suite installation, the License Application is installed and it is located under the Submenu of COZYROC SSIS+. To retrieve the License Key from the COZYROC server, follow these steps: IMPORTANT: The License Application ...
    • How to use the License Customer Form.

      We provide our customers with a License Customer Form.  Please see the screenshot below: You can use our License Customer Form to reset your license, to view the number of your registered machines against our license, to view the license update ...
    • How do I retrieve my license.dat file after it has been deleted?

      When Licensing COZYROC to a server, the License.dat file is placed in the C:\Program Files (x86)\CozyRoc\SSIS folder for a typical installation. Occasionally customers will want to move a license to a new server, but some event has taken place where ...
    • Is a License Key required on the passive node

      If you have a cluster with active and passive nodes, a License Key is required to be deployed on both nodes.  You will need to go through the same process as the active node for the passive node in deploying the License Key.  However, there is no ...