title: VBA - SQL Server 2014 - How to access localhost - Windows Authentication
body: <p><strong>VBA - SQL Server 2014 - How to access localhost?</strong></p>
  
  <p>Pretty much, I need to access localhost of SQL Server and I have tried almost anything I found here:</p>
  
  <p><a href="https://stackoverflow.com/questions/5283727/what-is-the-sql-connection-string-i-need-to-use-to-access-localhost-sqlexpress-w">What is the sql connection string I need to use to access localhost\SQLEXPRESS with Windows Authentication or SQL Authentication?</a></p>
  
  <p>I have tried this:</p>
  
  <pre><code>    str_connection_string = "Data Source=localhost\SQLEXPRESS;Initial Catalog=Tempt;Integrated Security=True;"
      str_connection_string = "Data Source = .\\\\SQLEXPRESS;Initial Catalog=Tempt;Integrated Security=True;"
  </code></pre>
  
  <p>And both return error:</p>
  
  <p><a href="https://i.stack.imgur.com/hVvbP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hVvbP.png" alt="enter image description here"></a></p>
  
  <p>This is a German Run-Time error, saying something about OLE DB. (My German is also not in my top 4 languages).</p>
  
  <p>I want WindowsAuthetication. The automatic one, without username or password.</p>
  
  <p>So what are the ideas?
  I use MSSQL Management Studio 2014.
  ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++</p>
  
  <p>A day has passed. this is what I tried in the morning:
  @GuidoG
  I liked the idea, but I did not succeed to make it in a way. What should be the servername on the top (point 1), in order to find my DB (point 3)?</p>
  
  <h2><a href="https://i.stack.imgur.com/8r3gX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8r3gX.png" alt="enter image description here"></a></h2>
  
  <p>@Comintern
  The local server, to which I am connecting through the MS DB Studio looks like this:</p>
  
  <h2>(localdb)\MSSQLLocalDB</h2>
  
  <p>Edit: I am trying to connect to localhost.</p>