title: How to connect to external database through SQL Server Management Studio?
body: <p>So I have a server, being hosted by an external hosting provider. To work on the server, I just need to remote connect with an IP address, a username, and password. When I remote connect, I can open SQL Server Management Studio and work on the databases. I use:</p>
  
  <pre><code>Server Name: (local)
  Authentication: Windows Authentication
  Username: SERVER\Administrator (Administrator is the username to remote connect)
  </code></pre>
  
  <p>I would like to connect to the server databases from SQL Server on my local machine. I obviously can't use <code>(local)</code> as the Server Name, and I can't use Windows Authentication.</p>
  
  <p>I'm terrible with configuring things like this, and I really don't even know what to search for. Do I need to set up something in SQL Server on my server? Or can I use the credentials for the server to connect?</p>