Unix Technical Forum

Error Connecting to SQL on Cluster

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 ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > MS SQL ODBC

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 10:02 PM
sibscard
 
Posts: n/a
Default Error Connecting to SQL on Cluster

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!


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 03:27 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com