title: Access Denied Error While using UNC path
body: <p>I am using SQL Server 2008 and I am getting an Access Denied error while trying to do a <code>BULK INSERT</code> which is accessing a network path, in the form: <code>\\network_ip_address\Localdiskname$\filename_with_extenstion</code>.</p>
  
  <pre><code>BULK
  INSERT TableName
  FROM '\\10.1.10.100\d$\Temp.csv'
  </code></pre>
  
  <p>How should I write the query correctly?  How do I specify network authentication credentials such as username and password in the query?</p>