How can we help you today? How can we help you today?

Server Drop Down List

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
0

Comments

5 comments

Sort by
  • Brian Donahue
    Hi,

    Can I get back to you on this tomorrow? I'm checking with my colleagues about this.
    Brian Donahue
    0
  • 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
    0
  • 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
    0
  • 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
    0
  • Brian Donahue
    I can positively confirm that we've fixed this problem now in version 4. Thanks for your patience!
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.