title: intermittent ERROR, Microsoft SQL Server Native Client 11.0 : Named Pipes Provider: Could not open a connection to SQL Server [5]
body: <p>I have a .vbs script which is carrying out some modelling. This script is fired via a windows scheduled task and performs a fair amount of database selects, inserts and updates.</p>
  
  <p>It has run many times over the years on SQL Server 2008 R2. Its now trying to run on win2016 Server running SQL Server 17.4. The job will run for a couple of hours ideally. Its stopping a little over an hour after almost 10,000 successful inserts, it throws me this error:</p>
  
  <blockquote>
    <p>Database Error: -2147467259 Microsoft SQL Server Native Client 11.0 : Named Pipes Provider: Could not open a connection to SQL Server [5]. </p>
  </blockquote>
  
  <p>Is this SQL Server taking its resources back for some reason? Any ideas on resolving this would be very helpful?</p>
  
  <p>Update : I have reduced the workload of the script. Instead of running for a couple of hours it now runs for less than one hour.  The first two runs have been successful, no issues.    </p>