title: error: 40 - Could not open a connection to SQL Server
body: <p>Hi I'm writing a simple console application to save XML data into the database using bulkcopy but am currently having problems connecting to my database.</p>
  
  <p>I am getting a SqlException error:</p>
  
  <blockquote>
    <p>A network-related or instance-specific error occurred while
    establishing a connection to SQL Server. The server was not found or
    was not accessible. Verify that the instance name is correct and that
    SQL Server is configured to allow remote connections. (provider: Named
    Pipes Provider, error: 40 - Could not open a connection to SQL Server)</p>
  </blockquote>
  
  <p>I have checked for issues ensuring my SQL server is running and that it's configured correctly. Below is my connection string.</p>
  
  <pre><code>string connectionString = @"Data Source=SYAZANA;Initial Catalog=WangSCM;integrated security=true;" ;
  </code></pre>
  
  <p>I'm at my wits ends trying to figure out the error, what is the mistake that I'm making?</p>