Home / server / Questions / 801336
Accepted
user2713516
Asked: 2016-09-07 04:49:00 +0800 CST

Connecting to named SQL Server 2016 instance

  • 772

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.

windows sql-server hamachi azure

2 Answers

  1. 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.

    • 2

  2. This may seem kind of silly, but try adding the remote computer's name to the hosts file with the ip over hamachi and then try using it as though you were directly connected. (e.g. on the same LAN)

    • 0