How Do I Connect to SQL Server?

Question

How do I connect to a SQL server using my home computer? I ultimately just want to connect SQL to several CSV files that are on my desktop. Please let me know if you need additional information.

Answer 1

Check the box Trust server certificate and you're on the air.

I should add that this is not a good solution if you are in a larger network, as you could be subject to a so-called man-in-the-middle attack. The correct solution in that case would be to install a certificate on SQL Server which is then trusted by certificates in the Trusted Certificate stores on the users' machines.

However, for a network at home, nah, that's over the top. On my machines at home I run with Trust server certificate.

Answer 2

You need to click the “trust server certificate” checkbox and try again.