Server Drop Down List

Brian Donahue

Hello,

We get this list of servers from ODBC (some functions of the odbc32.dll). The way that this works is not fully documented as far as I can tell, but I do know that Microsoft SQL Servers respond to broadcast messages from ODBC clients that are trying to discover them.

There is also an option in the SQL Server configuration to hide the server from ODBC, so you may want to ask the DBA if they'd implemented that.

Brian Donahue

Hi,

Can I get back to you on this tomorrow? I'm checking with my colleagues about this.

Brian Donahue

Hi,

SQL Server Instance names are transmitted on TCP port 1434. Is there a possibility that you've got a firewall blocking this port?

Brian Donahue

Hi David,

If Slammer spreads using SQL Server discovery, then it makes sense that sysadmins are blocking the port off at the firewall. I'm sure that viruses probably discover SQL Server instances the same way that we do!

Brian Donahue

There are still a number of issues affecting the server dropdown (It doesn't seem to detect named instances of SQL Server, for instance). The next version (tentatively, v4) will have new logic for SQL Server discovery.

Brian Donahue

I can positively confirm that we've fixed this problem now in version 4. Thanks for your patience!