This tech note addresses critical changes to Microsoft's security protocols for authentication in Microsoft Exchange Online, a workaround offered by Microsoft, CygNet's response to this change in authentication for the General Notification Service (GNS) and Flow Measurement Service (FMS), and CygNet's release and patch plan for v9.7, v9.6, v9.5, and v9.4 for this issue.
This blog is intended for the FMS service operator to gain understanding of the relationship between the FMS service and the SQL Server FMS database.
When working with the FMS service and the SQL Server database connection it is important to note that each task will run in an executable thread within the executing multi-threaded FMS Service. When data is required from the database, each thread will initiate a unique session with the database to read/write the specific data. It is possible, for some long running task with minimal to no activity, for the database to close the session as part of the database service manager optimization processing. The FMS service will detect this state and cause the session to re-open when the FMS Service requires database access.