LOAD TABLE with UNC doesn't work

Since I have to go across the network, I'm trying to use the UNC. However, this won't even work when I'm using the UNC to point to the server on which this is run. I'm trying to restore a single table on 6.5. What is the obvious piece that I'm missing?

This works.

LOAD TABLE address
FROM DISK = 'd:MSSQLackupDBBackup.DAT'
WITH source='address'


This doesn't.

LOAD TABLE address
FROM DISK = '\server1d$MSSQLackupDBBackup.DAT'
WITH source='address'

[Ray Miao]

Did you use domain account to start sql services?


------------
at 3/28/00 3:34:45 PM

Since I have to go across the network, I'm trying to use the UNC. However, this won't even work when I'm using the UNC to point to the server on which this is run. I'm trying to restore a single table on 6.5. What is the obvious piece that I'm missing?

This works.

LOAD TABLE address
FROM DISK = 'd:MSSQLackupDBBackup.DAT'
WITH source='address'


This doesn't.

LOAD TABLE address
FROM DISK = '\server1d$MSSQLackupDBBackup.DAT'
WITH source='address'

[Deha Senbay]

What is exact the error message ?
" Access is denied"

Can you access the other server with xp_cmdshell
i.e xp_cmdshell 'dir \serverc$' If you can than it should work. otehrwise make sure your services run under domain account and the trust relationship is set up between the servers

------------
Ray Miao at 3/28/00 5:06:27 PM

Did you use domain account to start sql services?


------------
at 3/28/00 3:34:45 PM

Since I have to go across the network, I'm trying to use the UNC. However, this won't even work when I'm using the UNC to point to the server on which this is run. I'm trying to restore a single table on 6.5. What is the obvious piece that I'm missing?

This works.

LOAD TABLE address
FROM DISK = 'd:MSSQLackupDBBackup.DAT'
WITH source='address'


This doesn't.

LOAD TABLE address
FROM DISK = '\server1d$MSSQLackupDBBackup.DAT'
WITH source='address'