Stonefield Query is licensed on a per-user basis. That means each user who wants to create and/or run reports requires a license. Here's how licensing works:

  • Until Stonefield Query has been activated, it runs in "unactivated" mode and displays an initial "Welcome" dialog. One of the links in that dialog allows you to activate the program. If you click that link, the License Manager appears. Click the Add button to add a license. The registration number that appears is based on several factors, one of which is information about the system where Stonefield Query is installed (not necessarily the workstation it's running on, but the system where the program resides). Enter the serial number you were given when you purchased Stonefield Query and click Online to activate it. The activation code that appears is also based on several factors, including the registration number, serial number, and number of licenses purchased. Licensing information is stored in a file named SFQuery.lic in the Data subdirectory of the program folder. For an unlimited license file, the file is named Unlimited.lic.

  • Users in the Administrators user group (such as the ADMIN user) are the only ones who have access to the Maintain Users and Groups dialog. In that dialog, an administrative user can only define as many user names as there are licenses. They can also specify which users use which licenses if more than one type of license is installed. For example, if there are two Ultimate and five Basic licenses, they can define up to two Ultimate users and five Basic users.

  • When you log in, Stonefield Query does two checks. The first is how many users are currently running the program. If all licenses are currently in use (for example, five users are currently logged in and there are five licenses in total), you are informed of this and Stonefield Query terminates. The second check is whether another user is logged in with the same user name. If so, you are informed of this and Stonefield Query terminates. So, licensing is a combination of named users (you can only define as many user names as there are licenses) and concurrent use (only as many users as there are licenses can be logged in at the same time).

The License Manager in the Tools menu and Tools tab of the ribbon, which is only available for users in the Administrators user group, can be used to add or remove Stonefield Query licenses or see the currently installed licenses.

License types

There are two types of licenses:

  • Basic: Also known as Report Viewer, Basic users cannot create or edit reports and cannot schedule reports.

  • Ultimate: Also known as Report Designer, Ultimate users have full functionality.


© Stonefield Software Inc., 2023 • Updated: 01/20/21
Comment or report problem with topic