I am configuring multiple (named) instances of SQL Server 2016 on my Windows Server 2012 Azure VM. I have LogMeIn Hamachi installed on this VM and my own computer for a secure connection between the two.
I can connect to my default SQL instance by just using the IP in my SQL Server Management Studio, but connecting to my named instanced just doesn't work.
- I set the port to 1435 in Sql server config manager for all IP's
- I tried using the VM IP + "\instancename" and ip + ":1435"
- I tried using the Hamachi IP + "\instancename" and ip + ":1435"
I have Sql management studio installed on that specific VM and I can login to the named instance using the internal IP\instancename and also machinename\instance, but any attempt to connect remotely fails.