To configure sharing network license(s) between multiple databases, follow the steps below.
1.Choose a database to dedicate as a licenses server. This can be an empty EQuIS Database, an existing EQuIS Database or you can create an external license database as explained in the help article, License Server Management.
2.Verify that the second database has already been updated (see Update EQuIS Database).
3.Start EQuIS Professional and select any facility within the second database.
4.Open the ST_LICENSE table as explained below.
a.Click on Data Tables in the Open group on the Home tab of the ribbon.
b.Switch to System Tables In the Open window.
c.Select the ST_LICENSE table and click Open.
i.If the database does not have a ST_LICENSE table, go back to Update Database(s) as shown here and update the database(s).
5.Add a new record to ST_LICENSE as explained below.
a.Click Add... ST_LICENSE.
b.Add the information below In the new record.
i.APP_ID = 1023
ii.KEY_TYPE = 4
iii.LICENSE_SERVER = <database connection string>
6.Repeat the previous steps as needed for additional databases. EQuIS Professional does not limit the number of additional databases that can be linked.
7.Once saved ST_LICENSE.LICENSE_SERVER will become an encrypted key string.
Note: Depending on network security, the connection string may need further modification, e.g. a VPN may require that the Fully Qualified Domain Name (FQDN) be used, instead of the server name in the connection string.
SQL Server with Windows Authentication
Data Source=dbserver;Integrated Security=SSPI;Database=licensedb;
SQL Server with SQL Authentication
Data Source=dbserver;User ID=someusername;Password=somepassword;Database=licensedb;
Note: Connection strings are case sensitive with SQL Database connections.
The Office Hour video Managing Licenses with a Network License Server is available to view on YouTube.
Copyright © 2021 EarthSoft, Inc • Modified: 08 Apr 2020