Load data from File System to Remote SQL Server but getting error

[Pradeep23]

There are three computers A,B and C

A is Manager' computer in which Data is stored as File System
B is my desktop having SQL Server 2005
C is Main SQL Server 2005.
B is able to connect to C. But When I run query on C, I get error.

The query runs but Files are not getting loaded.
It simply says File not Found.

Can anyone have idea about this.
Thank you. Need some help.

[Oralloy]

If you're using the network drive letter for the files on your manager's system, and the server system (C) doesn't have the same drive mapping as your system, then it won't be able to find the files.

Alternately, the server (C) may not have the proper permissions to access the files on the manager's system (A).

[Pradeep23]

Thanks Oralloy for replying.....
Can you please explain me How to set up permissions for main (C) Server so that it reads file system data on Manager's computer....
I searched online and it says SQL Services should have permission to access that data...then only SQL Server will have access.....
Can you tell me how to set up SQL Services?...
Thank you again

[Oralloy]

You'll have to log into the main (C) server and use the file manager to map drive letter/letters for the files you want to import. That drive letter should be the same as on your system. If it can not be, then you will have to remember to make the change manually when you send commands to the main server (C).

Also, be certain to check the "Reconnect at login".

If you have a permissions issue, that's something entirely different. Get the network admin to help in that case.

Good Luck!