BioStar2 Cannot assign a door relay during using MS SQL 2014

Affected Products & Versions: BioStar 2 v2.4.1, MS SQL 2014


If a customer installs BioStar2 Server with MS SQL 2014, Biostar2 SW can't assign a relay for connected device due to MS SQL 2014.

The "relay already in use" error will occur as follows.

Issue Reproduction:

1. Install MS SQL2014 Express or Standard Edition

2. Install BioStar2


- A query issue for MS SQL 2014


1. Stop BioStar2 Server

2. Download MS SQL 2014 SP2

3. Update MS SQL 2014 SP2

3-1. Microsoft® SQL Server® 2014 Service Pack 2 (SP2) Standard Edition

3-2.Microsoft® SQL Server® 2014 Service Pack 2 (SP2) Express

4. Start BioStar2 server

5. Create a door and assign a relay