Differences

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

--- en:how_to_install_biostar_2_with_mssql [2022/11/02 14:54]
sungjun created
+++ 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 ======
-\\
-{{ :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. \\
@@ Line 16: / Line 13: @@
 . Choose the installation type as “Custom.” \\
+{{:en:mssql_install_1.png?600|}}
 . Click the first item on the list. \\
@@ Line 26: / Line 25: @@
 . After completing the installation, open SQL Server Configuration Manager. \\
+{{:en:mssql_install_2.png?600|}}
 . Right-click “Protocols for SUPREMA” and click “TCP/IP Properties.” \\
@@ Line 40: / Line 41: @@
 . Create 3 New databases. Right-click Databases and select New Database. Name the Databases “BioStar2_AC,” “BioStar2_TA,” and “BioStar2_VE.” \\
+{{:en:mssql_install_3.png?700|}}
 . In the Database Files section, we recommend setting the Initial Size (MB) to 3000 and setting the Autogrowth/Maxsize to (By 10MB, Unlimited). \\
+{{:en:mssql_install_4.png?700|}} \\
+{{:en:mssql_install_5.png?700|}}
 . Expand Security and right-click Logins. Select New Login. \\
 . Choose Login name. It is recommended to choose biostar2. Then select “SQL Server authentication” and set the password. \\
+{{:en:mssql_install_6.png?700|}}
 . At “Server Roles,” select “sysadmin” to give privileges to the new user (biostar2). At User Mapping, select the newly created databases to assign to biostar2. Also assign biostar2 as the db_owner for each database. This account will be used to log into the three MS-SQL databases. \\
+{{:en:mssql_install_7.png?700|}}
 ===== 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. \\
+{{:en:mssql_install_8.png?600|}}
 . 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 61: / Line 73: @@
 . After carefully reading the license agreement, select “I accept the agreement” and click “Next >” to proceed.\\
+{{:en:mssql_install_9.png?500|}}
 . 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|}}
 . Choose “Custom installation” as the Database installation type. \\
+{{:en:mssql_install_11.png?500|}}
 . 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). \\
 . Input the DB name based on the database created at the Server Management Studio. \\
+{{:en:mssql_install_12.png?500|}}
 . Select destination location for the installation. \\
 . 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|}}
 . Read the Responsibility for protecting personal information. \\
+{{:en:mssql_install_14.png?500|}}
 . Here, you can customize the port setting. Change the default port setting if that port is being used. \\
+{{:en:mssql_install_15.png?500|}}
 . 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|}}
 . 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 =====
 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 89: / Line 118: @@
 ''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 |}} \\