Cannot start shadow copy (VSS_E_WRITERERROR_NONRETRYABLE) (MS SQL server with ACT! software)
Article ID
2045
Product Version
AhsayOBM: 8.1 and above
Operating System
Windows
Symptom
| No. | Type | Timestamp | Log |
|---|---|---|---|
| info | |||
| * | info | ... | [Start] Backing up database... |
| erro | |||
| * | 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 the 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 the SQL Server (ACT7), and select Properties
-
Change Log on as a setting from:
Built-in account: Local System
to
Built-in account: Local Service
