EN - Installing SQL Server and Work-IT
How do I install SQL Server and Work-IT ?
Installation manual SQL Server and Work-IT
This manual is to help you with the installation and setup for the software you need to use Work-IT
You'll need the installation folder with the following content:
- Installer
- Backup ( demo database )
- License
- Backup ( demo database )
- License
The installation of the SQL server 2017:
2. Choose your language and click on Download
The download will start in Chrome it will appear in the lower left corner of your screen.
The download will start in Chrome it will appear in the lower left corner of your screen.
3. When the installation start, you’ll see the following screen appears, click on Custom to continue.
4. The screen below will appear , click on New SQL stand-alone server.
5. Check this option
✔ I accept the license terms
6. Click three times on Next. Now the Microsoft R and Python needs to be installed,
7. Select in the next window Default Instance and click on Next.
8. Check in the following window the option below and continue with Next.
✔ Grant perform Volume Maintenance Task Privilege to SQL Server Database Engine Service.
9. In the following window select Mixed mode and set the following password Work-IT012345!
This password you’ll need later on the installation procedure
Note: Starting from 15-10-2024 we switched to this new password instead of the old one Work-IT01!
Now the Microsoft R and Python needs to be installed,
10. click on Next -> Accept -> Next and again on Next to complete the installation
This can take up to 30 minutes
11. Go again to the window below to start the Install SQL Server Management Tools.
An webpage will open, download the most recent GA version of SSMS
Note
The newest tested version of SSMS is 17.9.1.
Just follow the below 2 steps in the website to download SSMS 17.9.1 version :
a.
b.
12. In the installation window, click on Install when the installation is finished click on close
13. Start the SQL Server Configuration Manager by searching in your Windows menu, when SQL Server Configuration Manager is not in your Windows menu open File Explorer and paste one of the file paths below in the File Explorer.
| SQL Server 2017 | C:\Windows\SysWOW64\SQLServerManager14.msc |
| SQL Server 2016 | C:\Windows\SysWOW64\SQLServerManager13.msc |
| SQL Server 2014 (12.x) | C:\Windows\SysWOW64\SQLServerManager12.msc |
14. Go trough all the titles on left side of the window, when in the right Aliases / Protocols appears click on this and enable all features
In the window SQL Server Network Configuration.
Click with right mouse on Shared Memory and select Enable.
Click with right mouse on Named Pipes and select Enable.
Click with right mouse on TCP/IP and select Enable.
15. Click in the left menu on SQL Server Services with right mouse click on SQL Server MSSQL click on Properties and set the Start Mode on Automatic
16. Click in the left menu on SQL Server Services with right mouse click on SQL Server MSSQL and then click on Restart
Note: Changes will only take place after a restart
17. Open Windows Firewall with advanced Security menu.
18. Click on outbound rules and create a New rule
19. Select Port
Click on Next
20. fill in the specified ports at Specific local ports: 80,8080,12345,12346,1433,1434,1471,51211,51212
Click Next,
21. select Allow the connections
select
Click Next
22. Give the rule a name Work-IT Ports and click on Finish
23. Open Windows Firewall with advanced Security
24. Click in Inbound rules and create a New Rule
25. Select Port
26. Choose this time for UDP
Select Specific local ports and fill in 1434
Click Next,
27. select Allow the connections
select
Click Next
28. Give the rule a name Work-IT Ports and click on Finish
Add both TCP and UDP ports to both outbound rules and Inbound rules just to be sure.
------- Now the SQL Installation is completed. -------
The installation of the Work-IT:
1. Create a folder on C:\ and make sure you have read and write rights call the folder WorkIT.
The directory will be C:\ WorkIT.
2. In this folder create a folder with the name License and copy the license file in there.
3. Copy the Item from a by Hoogendoorn supplied folder in to the C:\ WorkIT directory
The folder will contain the following items:
- Installer
- License file (.LIC)
- Backup file (.BAK ) demo database
4. Open the Installer folder and start the Installer.exe
5. Click Basic installation to continue, General installation settings, standard default directory veld C:\WorkIT and click on Next
6. Fill in CMD in the start menu and open the Command Prompt
7. Type commando echo %computername% then press Enter key on your keyboard.
You see that the computer name in this exampel is NBNI014.
8.Now you can fill the folowing informations ( see the window below)
Servername : NBNI014
Database: WorkIT
Create database ✔
Backup/restore ✔ C:\WorkIT\Backup
Autenthication: SQL Server authentication
Username: sa ( sys admin )
Password Work-IT012345! ( this password you created during the SQL installation )
9. Test the connection by clicking on Test the connection , if the connection is not OK check your filled in fields and try again.
If you connection still does not work, ask Hoogendoorn for help.
10. Click on Next if the connection is OK
11. In the screen below you’ll need a license via (1) Select new license and fill in de the 8-digit (2) verification code supplied with the lic file.
Check if the license file ( .lic) in combination with verification code match with check license.
Check if the license file ( .lic) in combination with verification code match with check license.
Company code: HGM (automatically filed in if the license is added )
License: open the directory to the C:\WorkIT\License and select the license file
When the following text appear New/updated license is valid the license accept the company code and click on (3) Next.
12. For software demo purposes you’ll only need to select the following:
- Databasetool
- Work-IT Client ( ClickOnce)
- Work-IT Service
13. When you’re also going to connect hardware ( terminals, door controllers etc. )
you also need to select:
- Work-IT Hardware Service
✔ Backup previous versions.
✔ Start Service
14. Click on Next followed by Start installation,
this can take up to 10 minutes. If the installation will stop please contact Hoogendoorn.
15. After the installation is finished go to the Work-IT directory C:\WorkIT\ and open Work-IT Client ClickOnce and run the Setup.exe
After the installation of the setup is finished you’ll see Work-IT icon on your desktop
Login with the following credentials
Username : HGM
Password : (Please contact Work-IT support team for the latest password)
16. Now you’ll have an empty database, if you want to restore a demo database continue with the following steps.
Go to Service
17. Stop the Nitea – Service
18. To restore the demo database,go to C:\WorkIT\ and copy the .BAK file in to the backup directory C:\WorkIT\Backup
19. Go to SQL Server …. Management Studio
20. Fill the folowing:
Database Engine
HOO-LT-0065 ( your computer name )
SQL Server Authentication
sa
Work-IT012345!
Click on Connect
21. Click with a right mouse click on the WorkIT
22. Click on Restore and select Database
23. Select Device go to click on … and go to the C:\WorkIT\Backup\ and select the .BAK file
24. In the screen below click on Options , ✔Overwrite the existing database go back to General and click on OK
Restoring the database will take about 5 minutes depending on the database size
25. Start the Nitea – Service again in the Service window
26. The demo database you can login via with the following credentials , don’t forget to set the language setting.
Username : HGM
Password : HGM
------- Now the Work-IT Installation is completed. -------
Note:
It is very important to backup Work-IT database, here in the following article, you can see more information about backup:
EN - Backup Work-IT database
Related Articles
EN - Work-IT client PC software installation via folder share and internet explorer
Question How can we install Work-IT client PC software via folder sharing and internet explorer ? Answer If we want to do a second installation on another PC in the same network, we can do a Client installation, by following those steps: 1- Work-IT ...EN - System requirements of Work-IT
What are the system requirements of Work-IT? To install and run Work-IT there are some system requirements. Below you find the minimum system requirements, the Work-IT server requirements and the requirements of the Work-IT client. System ...EN - Work-IT: Setup Course - Basic
Question How to start quickly with Work-IT? Answer If you want to get to know how to setup Work-IT, you can do the free online course in the Hoogendoorn AcadeMe. But if you want to have a quick look at the videos about Work-IT then click the ...EN - Using the interface of Work-IT
I am new to Work-IT. Can you give some tips and tricks on how to use the program? We want to make working with Work-IT as easy and fun as possible. Have a look at the video below for some trips and tricks. Want to learn more about how to work with ...EN - Creating a report in Work-IT
How do I create a new report in Work-IT? You can create a new report in Work-IT in several ways. Each tab of Work-IT has its report button from which you can start a report. The video below shows an example of how to setup a simple report. This can ...