No Access to mapped drives

Hi,
I have a Wndows 2003 server running SQL Server (SP 3a).
My problem: Neither via Enterprise Manager nor T-SQL is it possible to do a
backup / restore on a mapped network drive. Using Query Analyzer, an error
shows up saying "Backup medium <xyz> cannot be opened. Media error or medium
offline", using Enterprise Manager, no network drive is being shown at all.
Strange enough, it is possible to list and access all network drives in the
(file-) explorer from this server. I do not consider this to be a security
issue, as the sql server runs under the domain administrator's account
having all required permissions. The network drives are assigned to
different servers, all of which belong to the same domain as the sql server.
The domain administrator is permanently logged on the sql server so the
network drives are present all the time.
It makes no difference if I run the Enterprise Manager directly on the sql
server or from a different machine. It also makes no difference if the
connection to the sql server is established using Integrated Security or sql
server's sa account.
There is another sql server in our domain which is configured identically,
apart from running under Win 2000 Server. This one has no problems accessing
any network drives...
For different reasons I do want to use a mapped drive instead of an UNC
path, so I hope someone can help me )
Thanks in advance,
OlafHi,
Start the SQL Server service using a Domain user which has got rights in
remote server share. After that you will be able to access the remot path
from query analyzer.
backup database dbname to disk='\\remoteserver\backupshare\dbname.bak' with
init
Note:-
Enterprise manager will not show the mapped drives
Thanks
Hari
MCDBA
"Olaf Gebert" <OGebert@.Eurocamp.de> wrote in message
news:eyyKXLtUEHA.2844@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I have a Wndows 2003 server running SQL Server (SP 3a).
> My problem: Neither via Enterprise Manager nor T-SQL is it possible to do
a
> backup / restore on a mapped network drive. Using Query Analyzer, an error
> shows up saying "Backup medium <xyz> cannot be opened. Media error or
medium
> offline", using Enterprise Manager, no network drive is being shown at
all.
> Strange enough, it is possible to list and access all network drives in
the
> (file-) explorer from this server. I do not consider this to be a security
> issue, as the sql server runs under the domain administrator's account
> having all required permissions. The network drives are assigned to
> different servers, all of which belong to the same domain as the sql
server.
> The domain administrator is permanently logged on the sql server so the
> network drives are present all the time.
> It makes no difference if I run the Enterprise Manager directly on the sql
> server or from a different machine. It also makes no difference if the
> connection to the sql server is established using Integrated Security or
sql
> server's sa account.
> There is another sql server in our domain which is configured identically,
> apart from running under Win 2000 Server. This one has no problems
accessing
> any network drives...
> For different reasons I do want to use a mapped drive instead of an UNC
> path, so I hope someone can help me )
> Thanks in advance,
> Olaf
>