I have an Excel application that checks the values on all nodes in a collective to be sure they are identical. But I keep running into problems with Tag Search being unable to query the server because the connection is closed. But if I try to open it I get "The server is already open under a different connection string. Close the server before attempting to reopen it."
I have iterated through all four servers on the collective and attempted to close each connection, but I get the error "Attempt to close server which is not open." for each server. Closing Excel typically works, but is an unacceptable solution.