title: "SQL Server does not exist or access denied." upon VB.Net Deployment
body: <p>Have built a small VB.Net app in VS2010.</p>
  
  <p>The connection string to the SQL Server is as follows:</p>
  
  <pre><code>    &lt;connectionStrings&gt;
      &lt;add name="IWSR_DataDownloadWizard.My.MySettings.sqlConnection"
          connectionString="Provider=SQLOLEDB.1;Data Source=SQLServer;Integrated Security=SSPI;Initial Catalog=IWSROL"
          providerName="System.Data.OleDb" /&gt;
  &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>Within the VS2010 environment AND on my machine, the connection works perfectly, however when I deploy to clients I get an error message of: </p>
  
  <blockquote>
    <p>[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.</p>
  </blockquote>
  
  <p>I've tried to search the net for solutions, have seen a few instances of people saying to NOT use the Server Name but the IP Address instead (this doesn't work) and some saying to remove the "Provider=SQLOLEDB.1", again this doesn't work.</p>
  
  <p>Can anyone suggest a solution please?</p>
  
  <p>Further information:</p>
  
  <p>Development System is Windows7 using VS2010
  Deployment systems are a combination of Windows XP, Windows 2000 and Windows 7
  SQL Server is SQL2000 (soon to be SQL2005).</p>
  
  <p>TIA</p>