This is a discussion on Error Connecting to SQL on Cluster within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Hello all, I'm having a strange problem on connecting to an SQL Server instante installed on a Cluster; We ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hello all, I'm having a strange problem on connecting to an SQL Server instante installed on a Cluster; We installed SQL Server 2003 on the Cluster at a time it was only connected to one LAN (network 100). After a while, we found necessary to connect the Cluster to another LAN (network 103). After that, we created a new resource on the cluster, from the type IP Address, giving it an address from the new LAN (network 103). Trouble here is that we cannot connect to SQL through ODBC to this new resource. We made some testing; Using another machine also connected to both LANs (networks 100 and 103) and found that we were able to connect to SQL only through the address that existed on the time of instalation (network 100). All connect attempts to the IP Address created recently (network 103) were unsucessfull. We also have made a test to a machine (non-cluster) with an SQL instance and found that we were able to connect to it using both networks. Can you assist me on this? How come we can't connect to SQL through this new resource? There is IP connectivity to that address... Thanks in advance. Best regards! |
| Thread Tools | |
| Display Modes | |
|
|