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

[Peter_io]

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?

[Roman Starun]

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>'