topic Re: SQL backup failing due to access issues while using the agent (HPStoreOnceForMSSQL.exe) in StoreOnce Backup Storage

SQL backup failing due to access issues while using the agent (HPStoreOnceForMSSQL.exe)

Peter_io — Fri, 04 Aug 2017 09:35:54 GMT

Hello There,

Have a requirement to use the HPStoreOnceForMSSQL.exe agent for automated backup to a catalyst store. Everything appears to have been configured correctly. My environment looks like this:

Storeonce - Catalyst store with permissions granted to all clients
HPStoreOnceForMSSQL.exe agent running on a remote SQL server

Used the agent GUI to add a catalyst store and everytime an attepmt to take a backup from the SQL server is made we get an access denied error message.

Can anyone help?

Re: SQL backup failing due to access issues while using the agent (HPStoreOnceForMSSQL.exe)

Roman Starun — Sat, 07 Apr 2018 13:14:16 GMT

Same problem.

Solution - HPEStoreOnceForMSSQLGUI.exe launched "as administrator", everything works as expected.

However running T-SQL expression fails with same error.

USE master;
exec sp_addextendedproc 'xp_StoreOnce','C:\Program Files\Hewlett-Packard Enterprise\StoreOnce\isvsupport\sql\bin\XP_HPStoreOnceForMSSQL.dll'

exec xp_StoreOnce '-info -store=<store>'