How to Fix Sage 300 Error License could not be found

Within Sage 300, when installing the workstation at the client end, one might run into several different issues with the desktop version, one of them being the How to Fix Sage 300 Error License could not be found on the workstation. Here in this article, we will try and understand the reasons and the solution for this particular error.  
Foremost, it is important to make sure that you have entered the correct license key or activation code. Next, be sure to double-check for any typos or errors in inputting the information. When you are sure that the license key is correct and still facing problems then this article can be followed to resolve the error..
Bear in mind, that encountering this problem does not necessarily imply that there is an issue with your license key itself. This could also be due to a temporary glitch or an error in communication between your workstation and the server file path.
So, If you come across the error message “A problem occurred, and a valid license for this product could not be found on the workstation” in Sage 300, then this could be due to the SharedData path within the registry not being the same as the actual Shared Data directory of Sage 300. Let us proceed with the reasons and the solutions for the problem:

Causes for Sage 300 Error License could not be found

Firstly, let us see why this error occurs; this error mainly occurs because the product updates are installed directly without installing the previous product updates. The user needs to install product updates in a sequence manner i.e., product update 1 needs to be installed first then product update 2, and so on.

Solutions for Sage 300 Error License could not be found

This may be caused by a Windows user account that has insufficient rights to the Sage 300 Shared Data directory and Sage cannot read the license files.

• Start by checking that the Sage 300 Shared Data directory path within the registry, HKLM\SOFTWARE\Wow6432Node\ACCPAC International, Inc.\ACCPAC\Configuration 
• Next, confirm that this is the same location displayed in the registry from a workstation(s) that can open a company successfully.
• Now, check the user permissions for the Sage 300 Shared Data directory.  Windows user accounts must have full access to the folders and sub-folders.
• Next, right-click on the Sage 300 'Shared data folder' and select Properties
• Click on the Security tab
• Verify that the Domain/user name is displayed in the Group or user names window 
• Highlight the affected user, and check the Permissions grid.  Ensure that 'Full Control' is selected for the user and that they have access to Modify, Read & execute, List folder contents, Read, and Write.

Also Checkout -> Sage 300 Workstation Setup and Installation Issues

Note: The above-stated methods have resolved a majority of these problems. However, in some cases, there is a second registry key within the HKCU\Software\ACCPAC INTERNATIONAL, INC. that could be causing the error.

Conclusion

So, there you have it people, these are some of the reasons, causes, and subsequent solutions when dealing with How to Fix Sage 300 Error License could not be found'. Was this article helpful? Do let us know in the space below and we would love to hear from you.

FAQs 

Q. How to activate my Sage 300 account?

A. To do this you need to:

• Log in as the Sage 300 ERP Admin user.
• Go to Administrative Services.
• Double-click on the Data Activation.
• Backup database if needed.
• Select the appropriate module to activate.
• Click on Activate.
• Close the Activation screen.
• Now your module should be activated.

Q. Is it possible to report errors within Sage 300?

A. Yes, to do this, you need to:

• Got to sage 300 ERP,
• Navigate to the General ledger
• Click on GL Reports
• Next, click on Posting journals
• Now click on Posting Journal errors
• Finally, click on a print button.

Once you click on the print button, the system will generate a report that will show all Journal posting errors.

Q. How do I set up Sage 300?

A. To do this, you need to:

• Click Start
• Next, click on All Programs
• Click on Sage 300
• Now click on Database Setup.
• Sign in using the administrator password.
• Click New.
• The New Database dialog box appears.
• Enter a database ID for the system.
• This must be the same as the DSN you created for this system database.
• You cannot change the database ID after creating the database.
• Now, select System as the database category.
• Click OK.
• Fill in the fields within the Edit SQL Server Database Profile dialog box, as follows:
  
  • Within the Description field, type a description for the database, using up to 60 characters.
  • The program displays the database ID that you entered in the New Database dialog box, but you can change it.
  • Now, select the data source name from the Data Source field, or specify the server name for the database in the Server field. (Only data sources created by you on your workstation appear in the list.
  • Note that the names of the data sources must be consistent on all workstations that use the same Shared Data directories. Remember, also, to type the name with the same capitalization that you used to define it with the ODBC Administrator.
  • Next, enter the Login ID that you created for all Sage 300 users.
  • Now, enter the Password for the Login ID you entered in the previous field.
  • When users sign on to Sage 300, the System Manager verifies their Sage 300 passwords, then logs onto SQL Server using the Login ID and password specified here.
  • Individual Sage 300 users do not need LOGIN IDs for SQL Server.
  • Enter the name of the database you created as the Sage 300 database. Make sure you use the same capitalization that you did when you defined it with the SQL Enterprise Manager.
  • If you intend to limit user access to accounting data, select the Enable Application Security option.
  • With security on, all access to application windows is then controlled by the Sage 300 security system. With security off, Sage 300 still uses the SQL Server Login ID and Password to gain access to the database, but it doesn't restrict access to Sage 300 users.
• Once you return to the Database Setup dialog box, the new system database is displayed in the list.
• Click the Security button to assign advanced global security for all users of companies that use this system database