Link to home
Avatar of pjordanna
pjordanna

asked on

Linked server data source - using a remote csv file

Hi experts,

I can get a linked server working fine with a local csv file - but when i try to change it to a unc path for example:

Data source: \\servername\c$\csvfiles

...it just can't see the csv's - has anyone out there done this before - is it possible?

many thanks,
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

check MSSQLSERVER service logon account - make sure it is NT domain user with admin rights on the "servername" - or create share folder with NTFS permissions
Avatar of imran_fast
imran_fast

Check if the user Login to sql server and the user specified in sql service and agent account have access on that location.
Avatar of pjordanna

ASKER

i've made a share on the remote server with the everyone group having full control.... still no joy
Try Creating a map drive on your server.
hi imran - yep tried mapping the drive - still no joy - I think SQL might need to be installed on the other machine perhaps?
ASKER CERTIFIED SOLUTION
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial