A A A

Please consider registering
guest

Log In

Lost password?
Advanced Search:

— Forum Scope —



— Match —



— Forum Options —




Wildcard usage:
*  matches any number of characters    %  matches exactly one character

Minimum search word length is 4 characters - maximum search word length is 84 characters

Topic RSS
Add network to MSSQL 2008R2 failover cluster
August 5, 2014
1:07 pm
Lo0oM
Admin
Forum Posts: 217
Member Since:
September 30, 2012
Offline

Hi

 

Description:

Windows 2008R2 nodes with installed MSSQL 2008R2 failover cluster. Need to configure cluster to listen on new network (create VIP).

 

Solution:

1. Need to configure IP's on both nodes on additional network cards, from same segment (10.0.0.0/24 for example).

on both nodes log in as domain admin:

win+R

ncpa.cpl

right click on NIC and choose tpc/ip v4. (i configured IP's 10.0.0.195 and 10.0.0.196)

 

Be sure both NIC's connected to the switch.

 

2. configure resource.

win+R

cluadmin.msc

Expand services and applications and right click on your MSSCQL service name:

Add a resource -> More resources…-> Add IP Address

 

3. You will see now new offline IP resource under Other Resources. Double click on it.

Choose network (10.0.0.0./24)

Static IP (10.0.0.199 in my case)

OK.

 

4. Right click on IP resource and choose:

Bring this resource online

 

5. Dependency setup.

right click on MSSQL Name in Server Name field.

choose Dependencies tab -> Insert -> in Resource field choose IP Address: 10.0.0.199

OK

 

6. Cluster restart.

Right click on MSSQL service name in Services and applications -> Take this service or application offline

wait until complete

Right click on MSSQL service name in Services and applications -> Bring this service or application online

 

It's all.

 

Thank you.

 

 

 

 

 

 

Forum Timezone: UTC 0

Most Users Ever Online: 31

Currently Online:
4 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 0

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 3

Forums: 20

Topics: 214

Posts: 214

Newest Members: Lo0oM

Administrators: Lo0oM (217)