https://login.veeam.com/en/oauth?client_id=nXojRrypJ8&redirect_uri=https%3A%2F%2Fwww.veeam.com%2Fservices%2Fauthentication%2Fredirect_url&response_type=code&scope=profile&state=eyJmaW5hbFJlZGlyZWN0TG9jYXRpb24iOiJodHRwczovL3d3dy52ZWVhbS5jb20va2IyNzk4IiwiaGFzaCI6ImY0ODQ2Mzg4LWNlNzAtNGUxOC1hYWI0LTkyZGY5ZmNhZjg3ZiJ9
1-800-691-1991 | 9am - 8pm ET
EN

Backup job fails with a SQL VSS Writer error after installing ACT! Software

Challenge

If you have an ACT! Software installed Veeam Agent for Microsoft Windows job or Veeam Backup & Replication job with Application-aware processing fails with the following:
 
Failed to create snapshot. Error code -2147212300. 'Backup job failed.
Cannot create a shadow copy of the volumes containing writer's data.
A VSS critical writer has failed. Writer name: [SqlServerWriter]. Class ID: [{a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}]. Instance ID: [{1d68f503-11fd-4591-9cf4-90e034386ae9}]. Writer's state: [VSS_WS_FAILED_AT_PREPARE_SNAPSHOT]. Error code: [0x800423f4].'
Cannot create a shadow copy of the volumes containing writer's data.
A VSS critical writer has failed. Writer name: [SqlServerWriter]. Class ID: [{a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}]. Instance ID: [{1d68f503-11fd-4591-9cf4-90e034386ae9}]. Writer's state: [VSS_WS_FAILED_AT_PREPARE_SNAPSHOT]. Error code: [0x800423f4]. (System.Exception)
At the same time these errors appear in Windows Application log:
 
Log Name:      Application
Source:        SQLWRITER
Event ID:      24582
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      TEST
Description:
Sqllib error: Failed to create VDS object. hr = 0x80770005.
Log Name:      Application
Source:        SQLVDI
Event ID:      1
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      TEST
Description:
SQLVDI: Loc=IdentifySQLServer. Desc=Initialize. ErrorCode=(1332)No mapping between account names and security IDs was done.
. Process=5728. Thread=70504. Client. Instance=ACT7. VD=.

Solution

Perform the following steps in order to fix the issue:
  1. Open SQL Server Configuration Manager.
  2. Navigate to  SQL Server Services.
  3. Select an appropriate instance (e.g., SQL Server(ACT7)).
  4. Change Log On  from  Built-in account: Local System   to   Built-in account: Local Service
KB ID:
2798
Product:
Veeam Agent for Microsoft Windows, Veeam Backup & Replication
Version:
9.x 2.x
Published:
2018-11-26
Last Modified:
2020-08-13
Please rate how helpful this article was to you:
5 out of 5 based on 1 ratings
Thank you for helping us improve!
An error occurred during voting. Please try again later.

Couldn't find what you were looking for?

Below you can submit an idea for a new knowledge base article.
Report a typo on this page:

Please select a spelling error or a typo on this page with your mouse and press CTRL + Enter to report this mistake to us. Thank you!

Spelling error in text

Knowledge base content request
By submitting, you agree that your personal data will be managed by Veeam in accordance with the Privacy Policy.
Your report was sent to the responsible team. Our representative will contact you by email you provided.
We're working on it please try again later