I have installed SQL Monitor successfully (good so far). Got the repository db setup, the base monitor installed and running, the web site up and running, etc.
I have added one of my servers, and SQL Monitor is gathering-and-reporting data for that server as expected (still good).
I also added my cluster server, and SQL Monitor successfully gathered the list of nodes (there are 2), and is showing "(local)" for the default instance.
BUT, it won't connect to the cluster instance (there is only one, and it's the "default") ... To connect to my default instance, I have to specify a port, like this: "SQLCLUS1,61790". That's what I use for connect strings, as well as with SSMS. But when I attempted to use that, SQL Monitor tried to add two servers: one called "SQLCLUS1" and one called "61790".
I tried stipulating the port using "SQLCLUS1:61790", but the server name box just turns red and no useful error / help information is available.
I also tried stipulating the port via the "Connection Properties" popup, but that didn't work either.
- It's not a permissions issue (I tried to use the wrong credentials initially and got the "wrong credentials" error; the error I'm getting now just says "Unreachable | Cannot connect")
- It's not related to connectivity or the like (I was able to run the full list of suggestions from another post -- ping, perfmon, regedit, wemtest (?) -- without a problem)
SO, what am I missing? Please.
- Joseph Marsh