Biostar VP5200SS16 Administrator Guide - Page 25
Con the MySQL Database, Con the BioStar Server
![]() |
View all Biostar VP5200SS16 manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 25 highlights
2. Install the BioStar Software name can be changed by editing the DBSetup.exe file. When patching the database server, you will have the option to manually select a datbase. 10. If you choose MS SQL Server, you must configure the authentication method as well (MySQL allows only server authentication): Server authentication: this option uses login IDs and passwords to authenticate users that are created by and stored on the SQL Server. These credentials are not based on Windows user accounts. Users connecting via server authentication must provide their credentials every time that they connect. Windows authentication: this option uses Windows users accounts for authentication. When users connect through a Windows user account, the SQL Server validates the account name and password using the Windows principal token in the operating system. The SQL Server does not ask for a password and does not independently validate user identification. Windows authentication is the default authentication mode for MS SQL Server. Note: You must choose the authentication mode that is supported by the database. You must also provide the proper credentials to create new tables in the database. 11. Click Setup to create the SQL database. 12. When the SQL database setup is complete, click Finish. 13. The setup program will perform a few remaining processes before the server installation is complete. Click Finish. Note: BioStar versions 1.3 and higher include drivers for connecting BioStation and DStation devices via USB in Windows 7. These drivers will not work with older versions of BioStar. If you are using an older version of BioStar be sure to install the correct USB drivers. 2.3.1 Configure the MySQL Database BioStar cannot use the MySQL database if the maximum packet size is less than 16MB. To configure the maximum packet size n MySQL server, locate and open a configuration file for the MySQL server ("my.ini" for a Windows system or "my.cnf" for a Linux system). Under [mysqld], add or edit the packet size to 16M or bigger (for example: max_allowed_packet=16M). After you have changed and saved the file, restart the BioStar Server for the changes to take effect. 2.3.2 Configure the BioStar Server In some cases, you may require manual configuration of the BioStar server. If you are having trouble connecting to the server from the client application, for example, you may need to alter your server settings. In addition, you must stop and restart the server application to apply any changes you have made to server configurations or database settings. 25 Copyright ©2014, Suprema Inc. On the web: www.supremainc.com
![](/manual_guide/products/biostar-vp5200ss16-administrator-guide-a0d6faa/25.png)