[V8] ISSUE: Cannot start shadow copy (VSS_E_WRITERERROR_NONRETRYABLE) (MS SQL server with ACT! software) [Ahsay Wiki]

[V8] ISSUE: Cannot start shadow copy (VSS_E_WRITERERROR_NONRETRYABLE) (MS SQL server with ACT! software)

Article ID: 8087
Reviewed: 2020-11-11

Product Version:
AhsayOBM: 8.1.0.0 to 8.x
OS: Windows

Problem Description

When performing a MS SQL database backup job on a SQL server with Act! CRM software installed, the following backup error is received in the backup report:

No.	Type	Timestamp	Log
*	...	...	...
*	info	...	[Start] Backing up database...
*	erro	YYYY/MM/DD hh:mm:ss	Cannot start shadow copy, reason =The writer operation failed because of an error that might recur if another shadow copy is created. (VSS_E_WRITERERROR_NONRETRYABLE)
*	...	...	...

Further checking on the SQL server, the SQL VSS writer 'SqlServerWriter' is in a failed state:

C:\WINDOWS\system32>vssadmin list writers
vssadmin 1.1 - Volume Shadow Copy Service administrative command-line tool
(C) Copyright 2001-2013 Microsoft Corp.

Writer name: 'SqlServerWriter'
    Writer Id: {a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}
    Writer Instance Id: {dae4567b-db13-43f6-aa28-21a7aface255}
    State: [8] Failed
    Last error: Non-retryable error
...

At the same time the following errors appear in Windows Application Event log:

Log Name: Application
Source: SQLWRITER
Date: DD/MM/YYYY h:mm:ss
Event ID: 24582
Level: Error
Keywords: Classic
User: N/A
Computer: Computer_name
Description:
Sqllib error: Failed to create VDS object. hr = 0x80770005.

Log Name: Application
Source: SQLVDI
Date: DD/MM/YYYY h:mm:ss
Event ID: 1
Level: Error
Keywords: Classic
User: N/A
Computer: Computer_name
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=.

Cause

The error is caused by Windows SQL VSS writer conflict with ACT! software.

Resolution

To resolve this issue:

Open the SQL Server Configuration Manager from the Windows Start menu.

Click the SQL Server Services item in the left pane.

In the right pane, right click on SQL Server (ACT7), select Properties.

Change Log on as setting from

Built-in account: Local System

to

Built-in account: Local Service

Keywords

ms, sql, mssql, databases

Sidebar

Announcement

Ahsay Backup Software

Backup Set Types

Supported Storage

Features in OBM / ACB

Features in CBS

Brand and Customize

License

Documentation

Performance Testing

FAQs and Known Issues

Can't Find What You Need?

Table of Contents