BioStar2 Cannot assign a door relay during using MS SQL 2014


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


Summary

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


Cause:

- A query issue for MS SQL 2014


Solution:

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

https://www.microsoft.com/en-us/download/details.aspx?id=53168

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

https://www.microsoft.com/en-US/download/details.aspx?id=53167

4. Start BioStar2 server

5. Create a door and assign a relay