How To change the permissions on the License file from inherited to explicit
If the correct permissions are not given to the License.dat file, you could receive the following error message:
"License file 'C:\Program Files (x86)\CozyRoc\SSIS\License.dat' has inappropriate permissions."
"License file 'C:\Program Files (x86)\CozyRoc\SSIS\License.dat' has inappropriate permissions."
In order to execute packages from the SQL Server Agent, make sure you have given explicit Read and Write permission to the COZYROC License.dat file. The Check box must be a solid black on the Read and Write permissions. If the Check box is a gray color, then the permissions from the parent folder are applied and you will need to convert the inherited permissions to explicit permissions.
- Right Click on the License.dat file and select the Properties from the sub-menu. Note: the License.dat file is located under the folder C:\Program Files (x86)\CozyRoc\SSIS.
- When the License.dat Properties Window is displayed, Click on the Security tab (See Figure 01).
- Click on the Advance button located at the bottom right corner.
- Select the user from the Permissions tab and then Click the Disable Inheritance button (See Figure 02).
- When the Block Inheritance Window is displayed, Click on "Convert inherited permissions into explicit permissions on this object." (See Figure 03).
- Click on the Apply and then afterward the Click OK button.
Note: after applying the changes to the License.dat file, you will need to restart the SQL Server Agent.
Figure 01 - License.dat Properties (Before)
Figure 02 - Advance Security Settings for License.dat
Figure 03 - Block Inheritance
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
Why do I get the following error when executing a package under a SQL Server Agent job: "Failed to decrypt protected XML node "ServerPassword" with error 0x8009000B..."?
The Execute method on the task returned error code 0x80004003 (Object reference not set to an instance of an object.). The Execute method must succeed, and indicate the result using an "out" parameter. ... and also: Failed to decrypt protected XML ...When executing an SSIS package from the command line, it works properly. However, when I run the same package from the SQL Job Agent, it fails.
Make sure your SQL Job Agent user account has the following permissions: COZYROC SSIS+ installation folder (READ and WRITE). Windows temp folder (READ and WRITE). The default location is here: C:\Windows\TEMP Permission to access COZYROC registry ...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 ...When I run an SSIS package under the SQL Job Agent with a proxy account, I get the error: Access Denied
Make sure your proxy account has permissions to access the following: 1. The SSIS+ installation folder 2. One of the following registry keys, depending on whether you're using the 32 bit or the 64 bit version: 32bit - ...