I have 2 Windows 2K servers with MS SQL 2000, clustered. Linked server was set up on a stand-alone sql server linking to Node A using the cluster name. Installed MS DTC and added it as a resource in the Cluster Admin on Node A (Node B was down at this point.) When I booted Node B, I received an error that wouldn't allow it to boot, but since Node A was up with all the data online on it and MS DTC running, I asked my developer to test his distributed query. When he did he received an error that MS DTC doesn't recognize the server name (same as the linked server and cluster name).
This is the first time I've dealt with distributed queries on a cluster, so I'm having problems getting the name resolution to work. When we added another linked server on the same stand-alone machine to another sql server that isn't clustered, everything works fine. What else can I do to help with the resolution?
This is the first time I've dealt with distributed queries on a cluster, so I'm having problems getting the name resolution to work. When we added another linked server on the same stand-alone machine to another sql server that isn't clustered, everything works fine. What else can I do to help with the resolution?