Cannot restore from a UNC file in sql 2005 management studio

Hi,
In sql 2005 management studio, when I tried to restore a database from disk
file saved on a UNC path, I got the following error.
The Database Engine service could not resolve the specified file location.
Either the location does not exist, or the current login account does not
have access to it. Verify that the file location exists, and that the login
account has permissions on it.
The following are the options I selected:
Source for restore: From device
Backup media: File
Selected path: \\home.dept.some.edu\me\sql2005\backups\
Files of type: Backup Files (*.bak, *.trn)
File name: db.bak
The error showed up when I clicked OK to start the restore process.
In Start->Run, the UNC path opens fine. So it's not the permissions issue.
And the path exists. Do I have to restore using the 'restore' command
instead of using the management studio GUI interface if I want to restore
from UNC?
Thanks in advance,
BingThe fully qualified domain name might be what is tripping it up - have you
tried specifying the IP address or using a non-qualified name. This is
assuming, of course, that this server is on the same domain that you're
trying to restore to...
"bing" wrote:

> Hi,
> In sql 2005 management studio, when I tried to restore a database from dis
k
> file saved on a UNC path, I got the following error.
> The Database Engine service could not resolve the specified file location.
> Either the location does not exist, or the current login account does not
> have access to it. Verify that the file location exists, and that the log
in
> account has permissions on it.
> The following are the options I selected:
> Source for restore: From device
> Backup media: File
> Selected path: \\home.dept.some.edu\me\sql2005\backups\
> Files of type: Backup Files (*.bak, *.trn)
> File name: db.bak
> The error showed up when I clicked OK to start the restore process.
> In Start->Run, the UNC path opens fine. So it's not the permissions issue
.
> And the path exists. Do I have to restore using the 'restore' command
> instead of using the management studio GUI interface if I want to restore
> from UNC?
> Thanks in advance,
> Bing|||Thanks for the response.
I tried the IP address, the same error.
The netwrok share and the sql 2005 server are not in the same domain.
Bing
"James Luetkehoelter" wrote:
[vbcol=seagreen]
> The fully qualified domain name might be what is tripping it up - have you
> tried specifying the IP address or using a non-qualified name. This is
> assuming, of course, that this server is on the same domain that you're
> trying to restore to...
> "bing" wrote:
>|||"bing" <bing@.discussions.microsoft.com> wrote in message
news:18DF4B33-FFB8-49B7-9526-E6AB310FDB34@.microsoft.com...
> Thanks for the response.
> I tried the IP address, the same error.
> The netwrok share and the sql 2005 server are not in the same domain.
>
Actually this probably IS a permissions issue.
The user context that the SQL is operating in is most likely not the same as
the one you're logged into to run SMS.
[vbcol=seagreen]
> Bing
> "James Luetkehoelter" wrote:
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||The SQLServer Service and SQL Agent windows services should always be set up
to login as domain-level accounts with appropriate permissions to access all
system-wide resources they may need access to. This especially includes
network file shares, which is almost certainly the problem here.
TheSQLGuru
President
Indicium Resources, Inc.
"bing" <bing@.discussions.microsoft.com> wrote in message
news:C2BD8088-BEE0-4581-9214-5D37F305118C@.microsoft.com...
> Hi,
> In sql 2005 management studio, when I tried to restore a database from
> disk
> file saved on a UNC path, I got the following error.
> The Database Engine service could not resolve the specified file location.
> Either the location does not exist, or the current login account does not
> have access to it. Verify that the file location exists, and that the
> login
> account has permissions on it.
> The following are the options I selected:
> Source for restore: From device
> Backup media: File
> Selected path: \\home.dept.some.edu\me\sql2005\backups\
> Files of type: Backup Files (*.bak, *.trn)
> File name: db.bak
> The error showed up when I clicked OK to start the restore process.
> In Start->Run, the UNC path opens fine. So it's not the permissions
> issue.
> And the path exists. Do I have to restore using the 'restore' command
> instead of using the management studio GUI interface if I want to restore
> from UNC?
> Thanks in advance,
> Bing