Generally speaking you would have a VPN connection that allows you to securely connect to the remote network which would then allow you to access the server using a remote desktop, or depending on the VPN settings, the SQL Server directly through Management Studio.