AIO600 SQL database snapshot fail

[Kimmo Pohjolainen]

Cannot take backup from SQL server database.
Take snapshot set fail. (VSS_E_PROVIDER_VETO)
Storage is domain member and SQL server is domain controller.
What can i do ?

[Carlton Bickford · Accepted solution]

VSS_E_PROVIDER_VETO means that the VSS provider on the application server could not complete the snapshot for some reason. That reason should be logged in the Windows application event log on your SQL Server machine.

In your case, you will probably see an error from WTSnapshotProvider that looks something like this...
"The iSCSI Software Target Volume Shadow Copy Service Hardware Provider service could not prepare the snapshot for LUN 0x00000003 on myAiO600.me.com. 0x80070005."

The 0x80070005 (access denied) error occurs when the application server is also a domain controller.

In this case, the following extra configuration should be performed:

1. On the application server, find the service "Microsoft iSCSI Software Target VSS Hardware Provider" in the services MMC snap-in. Click the Log On tab and change the account from ASMuser to a domain user of your choice. You may create a domain user for this purpose.

2. Do not delete the ASMuser account. Although it will no longer be used during snapshot creation, it will still be used to connect to the SQL Server instance when needed.

3. On the AiO system, make the domain account that you chose or created in step 1 a member of the local Administrators group.