Event ID: 7024 The SQL Server (MSSQLSERVER) service terminated with the following service-specific error: The data is invalid
This error can occur due to several reasons, including:
Corrupted system files or registry keys related to the MSSQLSERVER service.
Database corruption or inconsistency.
Incompatible database version.
Insufficient privileges for the MSSQLSERVER service.
An incorrect configuration or setting related to the MSSQLSERVER service.
An outdated or incompatible driver related to the MSSQLSERVER service.
A conflict with other applications or services running on the same server.
Troubleshooting
1). Please restart the SQL Server services, you can follow these steps:
From the search bar, please look for “Services”
Navigate to the "Services" and click “OK” or hit “Enter” on your keyboard.
Search for the SQL Server service corresponding to your database name.
Right-click on the SQL Server service.
Select "Restart" from the context menu that appears.
This should initiate the restart of the SQL Server service, allowing you to resume normal database operations.
Note: Please refer to this link on “How to Restart SQL Services”
2). Please run DBUpgrade for the Webgility Unify Enterprise software, you can follow these steps:
Open "File Explorer."
Navigate to the "Local Disk C" drive.
Search for the Webgility folder.
Open the "UnifyEnterprise" folder.
Right-click on the "UnifyDBUpgrade" executable file.
Select "Open" from the context menu that appears.
This should initiate the database update process. Please wait for the prompt indicating that the database has been successfully updated before proceeding further.
Note: Please refer to this link on “How to Run DBUgrade”
3). If you have an antivirus program installed on the computer where you are using the Webgility Scheduler, you may need to add an exception for the scheduler to prevent the antivirus program from interfering with its operation. Here are the steps you can follow to add an exception to the Webgility Scheduler:
Open the antivirus program on your computer.
Look for the settings or configuration menu.
Navigate to the section that deals with exclusions or exceptions.
Add an exclusion for the Webgility Scheduler, which is the unifyscheduler.exe file.
Save the changes and close the antivirus program.
By adding an exception for the Webgility Scheduler in your antivirus program, you can ensure that the scheduler can run without being blocked by the antivirus software.
4. To install the most recent version of SQL Server, which is SQL Server 2019 (since 2022 is still in the testing phase), follow the below-mentioned link to download SQL Server. Although the linked help article explains how to download SQL Server 2016, the process is similar to SQL Server 2019. Make sure to choose the "Custom" edition when installing SQL Server 2019.
Please free to let us know if the issue still persists.