<div>
check MSSQLSERVER service logon account - make sure it is NT domain user with admin rights on the &quot;servername&quot; - or create share folder with NTFS permissions
</div>


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

<div>
Check if the user Login to sql server and the user specified in sql service and agent account have access on that location.
</div>


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

<div>
i've made a share on the remote server with the everyone group having full control.... still no joy
</div>


i've made a share on the remote server with the everyone group having full control.... still no joy

<div>
Try Creating a map drive on your server.
</div>


<div>
hi imran - yep tried mapping the drive - still no joy - I think SQL might need to be installed on the other machine perhaps?
</div>


hi imran - yep tried mapping the drive - still no joy - I think SQL might need to be installed on the other machine perhaps?

<div>
<div class="content wysiwyg-content">
Hi experts,<br />
<br />
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:<br />
<br />
Data source: \\servername\c$\csvfiles<br />
<br />
...it just can't see the csv's - has anyone out there done this before - is it possible?<br />
<br />
many thanks,
</div>
</div>


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,

Linked server data source - using a remote csv file

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.