From BioStar 2.7.14, Windows Authentication Mode for MS SQL database Connection is supported. To use the Windows Authentication mode in your BioStar 2 Server, you need to configure the login account setting of MSSQL Database Server according to the article below.


<Notice>

  • If you used MS SQL Server Authentication mode in the former version and try to upgrade to BioStar 2.7.14 or later, you can select ONLY 'SQL Server Authentication' mode.
  • You can convert from 'SQL Server Authentication' mode to 'Windows Authentication' mode or in the opposite direction in BioStar 2.7.14 or later.


Depends on the Windows Account Policy of a server machine, there are two ways to configure MSSQL Windows Authentication.


1. Basic Configuration for Non-Active Directory PC environment

  • Run the MS SQL Server Management Studio.
  • Go to 'Security > Logins > NT AUTHORITY\SYSTEMS' and double click.
  • Go to 'Server Roles' and assign public and sysadmin roles.
  • Go to the 'User Mapping' page and choose master, AC DB, TA DB, and VE DB you created.



2. Basic Configuration for Active Directory PC environment

  • Login MS SQL Server Management Studio program with an administrator account.
  • Right-click at 'Security > Logins' and choose 'New Login...'.
  • Choose 'Windows authentication mode and click the 'Search' button.

  • Click the 'Locations' button and choose your Active Directory.


  • Check your name and click 'OK'.


  • Go to the 'Server Roles' tab and assign 'sysadmin' authority.


  • Go to the 'User Mapping' tab and make the default schema of the master, AC DB, TA DB, and VE DB to 'dbo'.
  • Click 'OK'.


* If you have installed BioStar 2 and MS SQL on different PCs, please follow the document linked below to perform additional settings.

[BioStar 2] Additional Settings for Windows Authentication of MS SQL Installed on Remote PC in Active Directory Environment



3. Installation Change

  • During the installation, you can find 'mssql windows auth.' check the box if you choose 'Custom Installation > MS-SQL'.
  • If Windows Authentication mode is activated, the ID and password input box will be deactivated.

  • Notice: If there is any issue during checking the DB connection, you cannot move on to the next step.