normally i connect to my sql server instance from my local computer, and then the server name to connect to is the name of my laptop. So i can connect to server instance 'MichelLaptop'
But now i'm trying to connect to my server from outside my network, and the first thing i wonder is: what is the name of the instance?
i've made a redirect to my local machine in the DNS of my domain, so i said (this is not the real data)
testsql.mydomain.com goes to 220.127.116.11
and when i ping testsql.mydomain.com, i get a response from 18.104.22.168
But what then is the server name?
EDIT: Should this also work from my local machine? (connect to the test.mydomain.com which routes back to my local machine?) As you probably figured out this doesn't work yet, but there are a lot of reasons i presume that could lead to this. Do i have to set anything specific to allow my sql server instance to allow remote connections?