Can't restore database from SQB file located on mapped drive
I am on Red Gate Backup version 126.96.36.199 on SQL 2005. I have my backup files on a hiddne network share that I have access to via a mapped drive. I am using the same account to authenticate onto the server and on the Red Gate Backup service.
When I try to restore a database by browsing for a backup file, I can browse and select the file, but the file shows up in the file selection box in the Restore Wizard with a red "X" box in the "OK" field. The error there says something like:
X:\Roswell\FULL_(local)_DYNAMICS_20100924_210032.sqb does not exist
In the filename box the filename itself is prefixed with "unavailable"
If I cope the file to a local drive, I can restore just fine, but this isn't an option for the larger backup files.
Running this command:
EXEC master..sqbdir '\\de08w2767\enrafgpbak$'
Gives me this error:
Msg 1, Level 16, State 1, Line 0
What can I do to troubleshoot this?
Thanks in advance,