LeanDESIGNER installation (MsSQL database)
This article describes the LeanDESIGNER installation, both server and client side, with database on MsSQL. It applies for LeanDESIGNER 1.0.20 or higher. For previous versions, please contact Hyperlean support.
1. Introduction
To install LeanDESIGNER you’ll need to download some files from a few links: you shall check for each “.zip” file you download that it does not have a security block and eventually disable it, by applying the following procedure:
- Right-click with the mouse on the downloaded “.zip” file
- Select “Properties” option in the context menu which will open and then go to the tab named “General”.
If the “.zip” file is blocked, you will see the button or the box “Unblock”. In this case:
- Press “Unblock” button or tick “Unblock”.
- Press “Ok” to save the changes.
2. Server-side configuration
Server-side, there are three main topics to highlight:
- License installation
- Creation of a shared folder
- Database restoration
The shared folder and the database can be created in the same server where LeanDESIGNER license is installed or in a different one.
2.1 License installation
First, you need to install the driver to manage the license by following next procedure:
- Download “LicenseDriverInstallation_8.41.zip” from Dropbox.
- Unzip the downloaded “.zip” file. The folder “LicenseDriverInstallation_8.41”, obtained from the unzip, contains the following 4 files:
- Run as administrator the file “InstallLicenseDriver.bat” (right-click à “Run as administrator”) to install the license manager driver.
- Check if the service Sentinel LDK License Manager is running, otherwise start it. To check it: write “Services” on Windows search bar.
Go to folder “LicenseDriverInstallation_8.41” and:
- Double-click on “RUS_GEWKM.exe” to run it
- In the “Collect status information” tab
- Select “Installation of new protection key”
- Click on “Collect information” button
Save the related “C2V” file (fingerprint) with the name of your server.
Send the fingerprint file by email to support@hyperlean.eu.
NOTE: “C2V” files do not contain private customer information. They contain information about the license terms and data stored in deployed Sentinel protection keys. For further information, please visit the provider’s webpage.
Hyperlean Support will send you back a “V2C” file that allows you to activate the license. To apply the file run “RUS_GEWKM.exe” then follow next steps (shown on next images):
- Select “Apply License File” tab
- Click the three points button to upload the “.v2c” file received by Hyperlean Support
- Click on “Open” button to open it
- Click on “Apply Update” button
Open a browser and go to http://localhost:1947/int/devices.html to check if the license has been installed. If so, you will see a line like the one in the next picture.
2.2 Creation of a shared folder
The second step is to create a shared folder called “LeanDESIGNER” with read permissions for all LeanDESIGNER users. Inside this folder, create the following subfolders:
- “Installer”: copy here the installation package and the registry file “AddRegistryKeysLD_64bit.reg”
- “Documentation”: save here the guides sent by Hyperlean
2.3 Database creation
In this chapter we describe how to create a LeanDESIGNER database on your SQL server.
Preliminary steps
Before you create the database, you must:
- Select or create an instance on the MsSQL server database where to upload LeanDESIGNER databases.
- Recover the port used for the remote connection to MsSQL server (by default it’s 1433).
- Create a specific user with the role of db_owner of the “LeanCOSTDB” and “LeanDESIGNERDB” databases. We suggest you name the user as “leanuser”. It is not necessary that this user has ”System Administrator” rights.
Database creation
The first step to do is to restore two “.bak” files received from Hyperlean to create the “LeanCOSTDB” and “LeanDESIGNERDB” databases.
Log-in the instance where the databases will be stored and right click on the “Databases” node, then select “Restore Database…” in the context menu.
The “Restore Database” window wil open: here follow the steps shown in the next picture.
Once pressed “OK” at step 6 of the previous image, the path of the file “LeanCOSTDB.bak” to restore will appear in the “Select backup devides” window: here press “OK” to go on with the restoration.
After having pressed “OK” you’ll be redirected to the “Restore database” window.
If you want to change the path where the data and log files will be savedelect “Files” in the left menu, check “Relocate all files to folder” and type the desired path in the “Data file folder” and “Log file folder” textboxes.
Make sure the paths are correct in the “Restore As” column.
Now, select “Options” in left menu and select “Overwrite the existing database (WITH REPLACE)” option and, finally, press “OK” button to start the restoration.
Once the restoration procedure has been completed, you’ll recieve this message meaning that the database was created.
The “LeanCOSTDB” will be listed under the “Databases” node.
After you restored the “LeanCOSTDB” database, you must repeat the same process to restore the “LeanDESIGNERDB” database as well.
Right click on the “Databases” node, then select “Restore Database…” in the context menu.
The “Restore Database” window wil open: here follow the steps shown in the next picture.
Once pressed “OK” at step 6 of the previous image, the path of the file “LeanCOSTDB.bak” to restore will appear in the “Select backup devides” window: here press “OK” to go on with the restoration.
After having pressed “OK” you’ll be redirected to the “Restore database” window.
If you want to change the path where the data and log files will be savedelect “Files” in the left menu, check “Relocate all files to folder” and type the desired path in the “Data file folder” and “Log file folder” textboxes.
Make sure the paths are correct in the “Restore As” column.
Now, select “Options” in left menu and select “Overwrite the existing database (WITH REPLACE)” option and, finally, press “OK” button to start the restoration.
Once the restoration procedure has been completed, you’ll recieve this message meaning that the database was created.
Both database will be listed under the “Databases” node.
Setting the “db_owner” user
To let LeanCOST open successfully with the updated database, it is necessary to check that the user created for the LeanCOST database (usually named “leanuser”) is “db_owner” of the “LeanCOSTDB” database.
Open “Security” node in the SQL instance where the LeanCOST database is stored. Open the subnode named “Logins”: here there will be the user created for LeanCOST database (suggested name = “leanuser”).
Select the user created for LeanCOST database, right click on it and select “Properties” voice in the context menu.
The “Login Properties” window will appear: select “User Mapping” on the left.
Then, select “LeanCOSTDB” database under the “User mapped to this login” table. Finally, check that “db_owner” is flagged. If it is not, select it and press “OK”.
After you set up the “db_owner” for the “LeanCOSTDB” database, you must repeat the same process for the “LeanDESIGNERDB” database as well.
Crypt and configure the connection string “.reg” file
Crypting operations of the strings to connect to “LeanCOSTDB” and “LeanDESIGNERDB” in MsSQL can be done on MsSQL server or on a client machine.
Before encrypting the registry keys, you need to add the keys in your System Registry.
Open the shared “…\LeanDESIGENER\Installer” folder and select the file “AddRegistryKeysLD_64bit.reg”. Right-click on it and click “Merge” from the context menu.
Click “Yes” then “OK” buttons respectively on the two windows that will open.
The procedure to follow to encrypt the connection string to the databases “LeanDESIGNERDB” and “LeanCOSTDB” in MsSQL is:
Download the file “LeanDesignerVSFConfigurationManager_X.x.x.zip” from the link Hyperlean Support sent you then unzip it. Run the application “LeanDesignerVirtualFileSystemConfigurationManager.exe” as administrator (right-click then “Run as administrator”).
The configuration manager will open:
Type in “ConfigurationLeanDESIGNERStorage” a string with the following syntax:
mssql;<DBServerName>\<InstanceName>;<Port>;<DBName>;<DBUserName>;<Password>;;;;
Where:
- <DBServerName> SQL server name where the db is stored
- <InstanceName> instance name where the db is stored
- <Port> port number used to connect to MsSQL, usually 1433
- <DBName> database name, usually “LeanDESIGNERDB”
- <DBUserName> username of the db_owner, usually “leanuser”
- <Password> db_owner user password
Then click “Write to registry” to add the key to the System Registry.
Type in “ConfigurationLeanCOSTStorage” a string with the following syntax:
mssql;<DBServerName>\<InstanceName>;<Port>;<DBName>;<DBUserName>;<Password>;;;;
Where:
- <DBServerName> SQL server name where the db is stored
- <InstanceName> instance name where the db is stored
- <Port> port number used to connect to MsSQL, usually 1433
- <DBName> database name, usually “LeanCOSTDB”
- <DBUserName> username of the db_owner, usually “leanuser”
- <Password> db_owner user password
Then click “Write to registry” to add the key to the System Registry.
To encrypt the value of the strings, flag “Crypt” by the value, then click “Write to registry”: do the same for both strings.
Do not close LeanDESIGNER Configuration manager.
Browse to the “…\LeanDESIGNER\Installer” folder and open the “AddRegistryKeysLD_64bit.reg” file with a text editor.
Here, you need to paste the crypted strings in their respective values: “ConfigurationLeanDESIGNERStorage” and “ConfigurationLeanCOSTStorage” .
You can either copy them from the LeanDESIGNER Configuration manager (right mouse click -> copy) or directly from your System Registry (Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\HyperLean\LeanDesigner).
Paste each encrypted string in the related key inside the “.reg” file.
You shall remain between quotes.
Save the updated file “.reg” the “…\LeanDESIGNER\Installer” folder.
If you added the registry keys on the SQL server, once you configured the file “.reg” as described above, you can delete them because they are not necessary.
Now you can install LeanDESIGENER on each client machine by following the procedure described on the next chapter.
4. Client-side installation
Log in to a client with a user with administrator permission.
Open the shared “…\LeanDESIGENER\Installer” folder, copy the “AddRegistryKeysLD_64bit.reg” file and paste it in your desktop: it contains the crypted string to enable the connection to the database on MsSQL.
Press right mouse button on the “AddRegistryKeys_64bit.reg” file that you pasted in your desktop and click on “Merge”.
Press “Yes” and “Ok” on the next two windows that will open.
Open the shared “…\LeanDESIGENER\Installer” folder and and temporarily paste the unzipped installer package on your desktop.
At the end of the installation, whether successful, you can delete it.
Run “Setup.exe” to install LeanDESIGENER (by double clicking with the mouse or from command line). The LeanDESIGENER setup process will automatically start.
In every machine where LeanDESIGENER is installed for the first time, some prerequisites will be automatically installed.
Click “Install” to accept the installation of the necessary prerequisites.
Next pictures show the installation progress.
The installation of the prerequisites is not always necessary: if a previous release of LeanDESIGENER had been installed on that client, they will not be installed again.
After the installation of all prerequisites, the LeanDESIGENER installation will start.
Tick “I agree” to accept EULA then click “Next”.
Press “Next” until the end of the procedure.
Click “Close” to end the installation.
To run LeanDESIGNER, double-click on the desktop icon.
Once the installation has ended, the login window of LeanDESIGENER will open: select language, type username and password, then click “Ok”.
Wait for the LeanDESIGENER interface to open.
If you run into any problems, contact support@hyperlean.eu.