I've been beating myself in the head about this one for a little bit. I'm trying to restore a backup to a company file into a new installation of Microsoft Office Accounting 2008. We made the backup on a workstation and are moving the installation to a server environment for multi-user support -- you know the drill. However, when I copy the backup (sbb) file into the root of the Local Hard Drive (or on the desktop, or in a folder somewhere) and try and restore it using the wizard (to a number of locations, all of which are unsuccessful), I get the following error:
"Cannot open backup device 'C:\path to random temp file.4vm'. Operating system error 5 (Access is Denied). RESTORE HEADERONLY is terminating abnormally." I don't know if it's important or not, but the temp file is located in the "C:\Documents and Settings\%USER%" tree, and we do Folder Redirection -- but only on the "My Documents" folder...
The error occurs when the status moves from "Decompressing data..." to "Restoring Company Data...".
The workstation was done as a standalone installation and therefore is using SQL Express 2005, the target of the restore is using SQL Standard 2005.
I've checked folder permissions, re-copied the file from the workstation by which it was generated, I'm logged into the server I'm doing this on as a Domain Administrator. -- And I'm stuck.