Probably a separate question, but: "If they are using a listener, in a single subnet, then it is transparent."...wondering if it is still transparent if using a legacy OLE DB provider, because this page implies that the client itself needs some smarts: learn.microsoft.com/en-us/sql/database-engine/…