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.
Best Answer
Each instance should run on its own port and as long as the SQL browser (port 1434) is running you should be able to access the individual instances using "HOST_NAME\INSTANCE_NAME". If you need to use the IP address the you should be able to reference these using "IP,PORT", notice the comma instead of a colon.