AppSync: SQL Recovery fails when the SQL instance AppSync is recovering to is running as a Service Account.

Summary: AppSync: SQL Recovery fails when the SQL instance AppSync is recovering to is running as a Service Account.

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms



The Service Account that the SQL instance is running, lacks sufficient permissions to access the mounted copy.

The AppSync Service plan event will show:
 
2017-10-13 08:27:00.869,Recover copy,fa3fb129-5f39-4681-99c5-f8a4f08xxxx,SQL_000098,HOSTNAME,The RESTORE command failed for database HOSTNAME\sqlinstance.DB. Check the SQL Server error log and the application event log for information. Try running the operation again.

The AppSync Plugin log on the recovery host will show:
 
2017-10-13 08:26:59.525 INFO  [21304]  []           [HOSTNAME] [a75edce0-447d-49bf-9c71-f768140xxxx] SQL: Waiting for the SQL RESTORE command to complete
2017-10-13 08:27:00.540 INFO  [21304]  []           [HOSTNAME] [a75edce0-447d-49bf-9c71-f768140xxxx] SQL: Last native error: error number 3283, SQLState 42000, sql native info message [Microsoft][ODBC SQL Server Driver][SQL Server]The file "PRODDBname" failed to initialize correctly. Examine the error logs for more details.

The AppSync Server log will show:
 
10-13-2017 08:27:00.869 INFO [Thread-23275 (HornetQ-client-global-threads-1761475520)] [com.emc.archway.service.eventservice.EventServiceBean] [xxxxAPPSYNCxx] [] EVENT [SQL_000098]: The RESTORE command failed for database HOSTNAME]\sqlinstance.DB. Check the SQL Server error log and the application event log for information. Try running the operation again.(METADATA: TYPE-ERROR, TIME-2017-10-13 08:27:00.869-0500NATIVETIME-2017-10-13 08:27:00.540-0500, HOST-HOSTNAME], PHASE-Recover copy, THREAD=21304, USER-BackupAdmin, CATEGORY-GENERIC, SESSIONID-jSLDHZquPYlwQyfBku2aJMc8E8STJlWISg3vxxxx)

Most importantly, the SQL Server log will show:
 
10/13/2017 8:26:59 AM spid 93FCB:Open failed: Could not open file C:\AppSyncMounts\xxx\Edrive\Data\DBname.mdf for file number 1. OS error: 5/(Access is denied).

Cause

AppSync does not support the use of Service Accounts, some of which end in a dollar sign, as the account used to run the SQL instance.

Resolution

Use a non-service account Domain user as the user which the SQL Service instance runs as.

Affected Products

AppSync

Products

AppSync
Article Properties
Article Number: 000057115
Article Type: Solution
Last Modified: 19 Aug 2025
Version:  4
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.