StoreOnce Backup Storage
cancel
Showing results for 
Search instead for 
Did you mean: 

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

 
Peter_io
Occasional Collector

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

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?

1 REPLY 1
Roman Starun
Occasional Advisor

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

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