Add second ip address to an existing SQl 2008 failover clustering

Posted by Cédric Boivin on Server Fault See other posts from Server Fault or by Cédric Boivin
Published on 2010-05-04T19:10:46Z Indexed on 2010/05/04 19:18 UTC
Read the original article Hit count: 222

Filed under:

failovercluster

|

failover

|

sql2008

|

clustering

|

networking

Hello,

I got actually a failover cluster on Windows Server 2008, with sql server 2008.

On each server i got two network card, with two different network one are on 10.10.10.x and other are on 192.168.99.x

I want my sqlserver cluster listen on the two network. Is it possible and how i add new ip address.

When i add a new ip address directly in the cluster, and i do a telnet on the 1433 port with the new cluster ip address it's not working.

Thanks

© Server Fault or respective owner

Related posts about failovercluster

Dell VRTX - slow cluster shared storage

as seen on Server Fault - Search for 'Server Fault'
I have a brand new Dell VRTX box set up as a Failover Cluster running HA Hyper-V virtual machines. This is my first time setting up clustering, and my first time with one of these boxes, so I'm sure I've missed something. The virtual machines are experiencing high disk latency and bad performance… >>> More
System Account Logon Failures ever 30 seconds

as seen on Server Fault - Search for 'Server Fault'
We have two Windows 2008 R2 SP1 servers running in a SQL failover cluster. On one of them we are getting the following events in the security log every 30 seconds. The parts that are blank are actually blank. Has anyone seen similar issues, or assist in tracking down the cause of these events?… >>> More
Cant turn off Redirected Access on Cluster Shared Volumes 2008r2 Failover clustering

as seen on Server Fault - Search for 'Server Fault'
I read up on LH Mode and am still boggled what it is and what it does. I pass all validation on the Failover cluster wizard but in the Event Viewer I get erros for Event ID 5121 and 1034 related to one of the disks that is in the CSV for my hyper v machines. We have two disks in the CSV for our hyper… >>> More
Cluster Shared Volumes Mount Point

as seen on Server Fault - Search for 'Server Fault'
I am using Cluster Shared Volumes on Windows Server 2008 R2 with Hyper-V. The different volumes available have different sizes, and are physically located on different disks on the SAN. These volumes defaulted to labels such as C:\ClusterStorage\Volume1. I know that it is not possible / recommended… >>> More
Hyper-V File Server Clustering - at my wit’s end

as seen on Server Fault - Search for 'Server Fault'
I am at my wit’s end with File Server clustering under Hyper-V. I am hoping that someone might be able to help me figure out this Gordian Knot of a technology that seems to have dead ends (like forcing cluster VMs to use iSCSI drives where normally-attached VHDX drives could suffice) where logic and… >>> More

Related posts about failover

SQL Server 2012 - AlwaysOn

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Ich war nicht nur irritiert, ich war sogar regelrecht schockiert - und für einen kurzen Moment sprachlos (was nur selten der Fall ist). Gerade eben hatte mich jemand gefragt "Wann Oracle denn etwas Vergleichbares wie AlwaysOn bieten würde - und ob überhaupt?" War ich hier im falschen… >>> More
Secondary DHCP server won't start on Centos 6.2

as seen on Server Fault - Search for 'Server Fault'
I'm trying to create a backup DHCP server. Server times are in sync. Primary server starts fine. Secondary server won't start. Error from /var/log/messages is: Sep 15 14:47:45 stream dhcpd: Copyright 2004-2010 Internet Systems Consortium. Sep 15 14:47:45 stream dhcpd: All rights reserved. Sep… >>> More
Un-failing over a Cisco PIX 515e

as seen on Server Fault - Search for 'Server Fault'
We had a power outage at our data center last week and when our dual PIX 515E running IOS 7.0(8) (configured with a failover cable) came back, they were in a failed over state where the Secondary unit is active and the Primary unit is standby I have tried 'failover reset', 'failover active', and… >>> More
Failover or load balancing configuration on Apple Xserve and Mac OS X Server Snow Leopard (10.6)

as seen on Server Fault - Search for 'Server Fault'
I'm currently installing a number of Apple Xserve boxes running Mac OS X Server (10.6). After poking and prodding for a while I can't find any obvious way, or documentation telling me how, to set up the 2 ethernet ports in a failover or load-balancing configuration. There seems to be an obvious… >>> More
SQL Cluster on Hyper V Failover Cluster

as seen on Server Fault - Search for 'Server Fault'
We have a VM running SQL Server on a 6 node cluster of blades. The VM's data files are stored a SAN attached using a direct iSCSI connection. As this SQL server will be running a number of important databases we're debating whether we should be clustering the SQL Server or will the fact that the… >>> More