Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
en:how_to_install_biostar_2_with_mssql [2022/11/02 15:07]
sungjun [MS-SQL Installation]
en:how_to_install_biostar_2_with_mssql [2022/11/03 15:25] (current)
sungjun [How to Install Certificate for BioStar 2]
Line 2: Line 2:
  
 ====== How to Install BioStar 2 with MSSQL ====== ====== How to Install BioStar 2 with MSSQL ======
-\\ 
-{ :​en:​how_to_install_biostar_2_with_maria_db.mp4?​900x506 |}} \\ 
- 
 BioStar 2 is a web-based, open, and integrated security platform that provides comprehensive functionality for access control and time & attendance. There are two types of databases to use in BioStar 2 (Maria DB and MSSQL). The databases each have different methods for installing BioStar 2. Here, we will cover how to install BioStar2 with MSSQL step-by-step. \\ BioStar 2 is a web-based, open, and integrated security platform that provides comprehensive functionality for access control and time & attendance. There are two types of databases to use in BioStar 2 (Maria DB and MSSQL). The databases each have different methods for installing BioStar 2. Here, we will cover how to install BioStar2 with MSSQL step-by-step. \\
  
Line 64: Line 61:
 ===== BioStar 2 Installation ===== ===== BioStar 2 Installation =====
 Before installing BioStar 2, please refer to the BioStar 2 Installation Guide at BioStar 2 Package to check the system requirements for your computer. \\ Before installing BioStar 2, please refer to the BioStar 2 Installation Guide at BioStar 2 Package to check the system requirements for your computer. \\
 +
 +{{:​en:​mssql_install_8.png?​600|}}
  
 1. Download the latest BioStar 2 Setup file at BioStar 2 Package. You can choose the (x64) or (x86) setup based on your computer’s system requirements. \\ 1. Download the latest BioStar 2 Setup file at BioStar 2 Package. You can choose the (x64) or (x86) setup based on your computer’s system requirements. \\
Line 74: Line 73:
  
 5. After carefully reading the license agreement, select “I accept the agreement” and click “Next >” to proceed.\\ 5. After carefully reading the license agreement, select “I accept the agreement” and click “Next >” to proceed.\\
 +
 +{{:​en:​mssql_install_9.png?​500|}}
  
 6. The first account that will be used to login to BioStar 2 will be the admin. Customize the admin password based on the password requirements displayed at the Setup. Please note that it is difficult to recover the admin password, so make sure to not forget the admin password once you have set it. Click “Next >” to proceed. \\ 6. The first account that will be used to login to BioStar 2 will be the admin. Customize the admin password based on the password requirements displayed at the Setup. Please note that it is difficult to recover the admin password, so make sure to not forget the admin password once you have set it. Click “Next >” to proceed. \\
 +
 +{{:​en:​mssql_install_10.png?​500|}}
  
 7. Choose “Custom installation” as the Database installation type. \\ 7. Choose “Custom installation” as the Database installation type. \\
 +
 +{{:​en:​mssql_install_11.png?​500|}}
  
 8. Choose DB Type as MS-SQL. Input the Server IP (you can see the Server IP by typing “ipconfig” on the Command Prompt). Input the Server port (Here, it is 1433 configured previously at MS-SQL). \\ 8. Choose DB Type as MS-SQL. Input the Server IP (you can see the Server IP by typing “ipconfig” on the Command Prompt). Input the Server port (Here, it is 1433 configured previously at MS-SQL). \\
  
 9. Input the DB name based on the database created at the Server Management Studio. \\ 9. Input the DB name based on the database created at the Server Management Studio. \\
 +
 +{{:​en:​mssql_install_12.png?​500|}}
  
 10. Select destination location for the installation. \\ 10. Select destination location for the installation. \\
  
 11. Select the folder for the Encrypt Key Storage Directory. The encrypt key is critical for operating BioStar 2, and please do not alter the location of the file or the file once you have set the location. Click “Next >” to proceed. \\ 11. Select the folder for the Encrypt Key Storage Directory. The encrypt key is critical for operating BioStar 2, and please do not alter the location of the file or the file once you have set the location. Click “Next >” to proceed. \\
 +
 +{{:​en:​mssql_install_13.png?​500|}}
  
 12. Read the Responsibility for protecting personal information. \\ 12. Read the Responsibility for protecting personal information. \\
 +
 +{{:​en:​mssql_install_14.png?​500|}}
  
 13. Here, you can customize the port setting. Change the default port setting if that port is being used. \\ 13. Here, you can customize the port setting. Change the default port setting if that port is being used. \\
 +
 +{{:​en:​mssql_install_15.png?​500|}}
  
 14. Select the components to be installed at BioStar 2. Choose the USB Device Agent if the installation of the USB Fingerprint Reader (BioMini Plus 2) or the USB Card Reader (DE620) is required. If you install the USB Device Agent, you will need to restart your computer to complete the installation process. \\ 14. Select the components to be installed at BioStar 2. Choose the USB Device Agent if the installation of the USB Fingerprint Reader (BioMini Plus 2) or the USB Card Reader (DE620) is required. If you install the USB Device Agent, you will need to restart your computer to complete the installation process. \\
 +
 +{{:​en:​mssql_install_16.png?​500|}}
  
 15. After the installation process has been completed, open BioStar 2 Settings to confirm the system status. Check the Service Status and the HTTPS Port. \\ 15. After the installation process has been completed, open BioStar 2 Settings to confirm the system status. Check the Service Status and the HTTPS Port. \\
  
 +{{:​en:​mssql_install_17.png?​500|}}
 ===== How to Install Certificate for BioStar 2 ===== ===== How to Install Certificate for BioStar 2 =====
 If you try to open BioStar 2 right after installation,​ you will get the following privacy error message. Currently, there is no certificate installed at BioStar 2. So, the web protocol is displaying “Not secure.” Please refer to [[en:​how_to_configure_https_settings_for_the_web_client|How to configure HTTP or HTTPS protocol]] for steps to install the certificate for BioStar 2. Then, it will be displayed as “Connection is secure.” \\ If you try to open BioStar 2 right after installation,​ you will get the following privacy error message. Currently, there is no certificate installed at BioStar 2. So, the web protocol is displaying “Not secure.” Please refer to [[en:​how_to_configure_https_settings_for_the_web_client|How to configure HTTP or HTTPS protocol]] for steps to install the certificate for BioStar 2. Then, it will be displayed as “Connection is secure.” \\
Line 102: Line 118:
  
 ''​Note:''​ For the best experience at BioStar 2, use Google Chrome as the browser to access BioStar 2. \\ ''​Note:''​ For the best experience at BioStar 2, use Google Chrome as the browser to access BioStar 2. \\
 +
 +----
 +\\
 +{{ :​en:​how_to_install_biostar_2_with_mssql.mp4?​900x506 |}} \\
 +