Event ID: 7024 The SQL Server (MSSQLSERVER) service terminated with the following service-specific error: The data is invalid
This article helps Webgility Desktop users resolve the SQL Server (MSSQLSERVER) service termination error (Event ID: 7024) that can occur during Webgility Desktop operations. It explains potential causes, such as system file corruption, permission issues, and configuration errors, and provides step-by-step troubleshooting instructions. These steps include restarting SQL services, running the Webgility DBUpgrade tool, adding antivirus exceptions for the scheduler, and installing SQL Server 2019 if required.
Error Message:
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.
Follow the steps in this helpful article 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.
Follow the steps in this helpful article 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 unifyschedulerservice 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 2022.
Follow the steps in this helpful article on: How to manually install SQL Server 2022 for Webgility Desktop