I have created this cluster on Amazon's EC2 service. I can connect to the sql instance from the first node (there is only one node in the cluster at this time) using the cluster name, so I know that much works.
I have another server in another Security Group (ports 1433 and 1434 opened between groups) that I am installing the SQL Reporting Services on. During the setup of the RS portion, it asks me to define a database or to create a new one. I want to point this RS instance at my SQL cluster, however I am presented with the error message in the title of this post, the troublesome -40 error.
I know the basics about resolving this (make sure Windows firewall holes are open, TCP/IP is enabled in Configuration Manager) but everything I find about diagnosing (or even configuring remote access) doesn't really address the cluster factor.
In Configuration Manager, TCP/IP is enabled, and listen all is set to yes, but in the tab where individual IPs are listed, none of them are 'enabled'. Should I enable both the node IP AND the cluster IP? Any? None?
I know I'm overlooking something probably very simple, but I'm stuck nonetheless.
Help!
This is a limitation of Amazon VPC at this time. An instance cannot and will not receive traffic for multiple IP addresses.