This video is a step by step walk-through on how to access a MSSQL server from anywhere in the world!

1) First we check for a connection.
2) Second make sure there is an instance of the database and a password secure user with admin rights that we can log in as.
3) Third we make sure that the server browser is running and TCP is enabled. Finally we get firewall out of the way. Then we see that it works!

Let me know if you have any questions. I mostly made this video for my own future reference but if it happens to make somebody’s life easier then that is great too.