I have an issue with ISA Server and SQL Server...
In SQL Server Management Studio there can be done a query for server instances to network servers. This is done by broadcasting to SQL Browser service through the subnet and servers those run browser service respond with their IP adresses and instance names. The problem with that is routers drop all broadcast packets by default and my SQL Server runs on different subnet from my actual LAN subnet, behind ISA Server:
So, ISA captures broadcast packet created by my terminal and drops it as expected... I'm seeking for relaying those packets created in 24.0 leg to 8.0 leg, like DHCP relaying...
I checked ISA for some kind of relaying broadcast messages but there're none that I encountered. We can do DHCP relaying by installing relay agent in RRAS, and creating access rules on ISA, like:
What I'm wondering is if there is a way to do a relay broadcast messages targeting sql browser service like dhcp above? Do I have to write a listener application to work on ISA computer (SQL Browser Relay Agent), or is there such app does that? What do you recommend?