"Enable Always On Availability Groups" Setting for SOTI XSight Database

Always On Availability Groups is a feature of SQL Server that allows you to create a highly available and resilient database environment.

This feature is available in two forms:

• Always On Failover Clustering Instances (FCIs)
• Always On Availability Groups (AGs). *1

When trying to enable Always On for SOTI XSight databases, the customer received the following error:

Source:

What is an Always On SQL Server availability group?

See for details: https://www.boltic.io/blog/always-on-sql-server#:~:text=Always%20On%20is%20a%20feature,On%20Availability%20Groups%20(AGs).

• On-premise Environment.
• SOTI MobiControl version 15.6.6.1010.
• SOTI XSight versions affected: 2024.0.3 and earlier
• SQL Server version: SQL Server Standard 2019
• Windows Version: Windows Server 2019

After SOTI XSight is completely installed, Always On setting for SQL Server Management Studio cannot be enabled.

This behavior does not affect SOTI XSight functionality, but the customer is not able to set the Always On feature.

While trying to enable Always On setting the SQL server shows an error indicating that the database is encrypted by the master key. A valid password must be used when adding it to the availability group.

The customer must be on SOTI XSight 2024.0.3 or higher.

Once the above-mentioned SOTI XSight version is installed and the process of enabling Always On is complete, the SOTI database must show "Synchronized" after the DB name.

This is a known issue for SQL Server and there are some troubleshooting steps to solve it. However, for SOTI XSight, it is not possible to drop the Master Key, and XSight developers have mentioned that there is no password to fix it.

Source: SQL SERVER - Always On Error: This Database is Encrypted by Database Master Key, You Need to Provide Valid Password When Adding it to the Availability Group - SQL Authority with Pinal Dave