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