Question :
I got the following error when backup Xin Inventory 2.0 database : Cannot open backup device ‘C:\Program Files\Xin\Xin Inventory 2.0\XinBackup\XinInventory.bak’. Operating System error 5 (Access is denied). BACKUP DATABASE is terminating abnormally. We suggest you restart Xin Inventory.
Answer :
This is due to the security setting in Xin Inventory 2.0 that not allow the MSSQL to access to it and write the backup file. Please refer to http://support.xincube.com/KB/a80/backup-fail-in-xin-inventory-20.aspx?KBSearchID=0 for the step by step solution.