title: 2014 SQL Server Connection to different PC on local network. VBA
body: <p>I trying to connect to an instance of 2014 SQL Server on Windows Server 2012 R2 standard over a local network without any success.</p>
  
  <ol>
  <li>I have gone into Configuration manager and enabled TCP/IP.</li>
  <li>I have gone into advanced settings on the server firewall and added new inbound     rules for all the SQL Server used TCP ports, </li>
  </ol>
  
  <blockquote>
    <p>135,1433,1434,2382,2383,4022</p>
  </blockquote>
  
  <ol start="3">
  <li>I have enabled sa authentication and set a new password.</li>
  </ol>
  
  <p>My connection string looks like this.</p>
  
  <pre><code>sConnString = "PROVIDER=SQLOLEDB;" &amp; _
                "Data Source=ServerName;" &amp; _
                "Initial Catalog=Staff_Manager;" &amp; _
                "User Id=sa;" &amp; _
                "Password=myPassword;" &amp; _
                "INTEGRATED SECURITY=SSPI;"
  </code></pre>
  
  <p>But , I get this error when trying to connect. </p>
  
  <blockquote>
    <p>[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
    access denied</p>
  </blockquote>
  
  <p>I checked the Databases name and password and that is correct.</p>
  
  <p>So I tried the Microsoft workaround found here, <a href="https://support.microsoft.com/en-us/kb/888228" rel="nofollow">Bug #: 471480 (SQL Server 8.0)</a></p>
  
  <p>And I came up with this connection string,</p>
  
  <pre><code>sConnString = "PROVIDER=SQLOLEDB;" &amp; _
                "Integrated Security=SSPI;" &amp; _
                "Persist Security Info=False;" &amp; _
                "User Id=sa;" &amp; _
                "Data Source=tcp:192.192.1.111,1433;"
  </code></pre>
  
  <p>But, I am still getting the same error. Anyone point me in the right direction as I have run out of solutions.</p>