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. You can use it this way for up to 30 days after the first time it was run. To activate the software, use the License Manager to add a license.

  • Licensing information is stored in a file named SFQuery.lic in the Licenses subdirectory of the program folder. For an unlimited license, the file is named Unlimited.lic.

  • The same holds true for Stonefield Query Studio; the only difference is the name of the license file, SQStudio.lic, in the Data subdirectory of the program folder.

  • There are two types of licenses: Report Designer and Report Viewer. A Report Designer license allows a user to create new reports, edit reports, and copy reports. With a Report Viewer license, the user can only run reports.

  • There's a subset of these license types: Subscription. A normal license can be used even if your software maintenance expires because you've purchased the software. A subscription license, on the other hand, isn't purchased outright but is instead paid for on a subscription basis similar to subscribing to a magazine. If you stop making subscription payments, the license becomes inactive and you can no longer use the software.

  • Users in the Administrator role (such as the ADMIN user) are the only ones who have access to the Security dialog. In that dialog, an administrative user can define user names and specify which users use which license type. For example, Mary may be assigned a Report Designer license while Bob gets a Report Viewer license.

  • When you log in, Stonefield Query does two checks. The first is how many users are currently running Stonefield Query. If all licenses are currently in use (for example, five users are currently in Stonefield Query and there are five licenses in total), you are informed of this and returned to the Login page. The second check is whether another user is logged in with the same user name. If so, you are informed of this and returned to the Login page. So, Stonefield Query licensing is sometime called "concurrent use" because only as many users as there are licenses can be logged in at the same time.

The Setup function in the Tools menu, which is only available for users in the Administrator role, can be used to manage licenses.