September 30, 2012
Windows 2008R2 nodes with installed MSSQL 2008R2 failover cluster. Need to configure cluster to listen on new network (create VIP).
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:
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.
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)
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
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
Most Users Ever Online: 31
Currently Browsing this Page:
Guest Posters: 0
Newest Members: Lo0oM
Administrators: Lo0oM (217)