Support for SQL Browser

jamiehowarth0's profile image jamiehowarth0 posted 2 years ago in General Permalink

I have multiple SQL Server instances installed on my machine. Recently, due to a Windows update, SQL Server Management Studio (SSMS) has stopped working, so I'm forced to use HeidiSQL for the time being until it's fixed.

When multiple SQL Server instances are installed, TCP ports are dynamically assigned instead of using port 1433, as they all can't listen on the same port. SSMS uses a UDP connection to port 1434, which then responds with the correct TCP port to connect to a specific instance, before then connecting to that port using TCP.

Can support for this behaviour be added to HeidiSQL?

Please login to leave a reply, or register at first.