It'll improve the fail over when you set the
database TCP ports to static instead of dynamic.
Implementation procedure:
- Open "SQL
Server Configuration Manager"
- Select
"SQL Server 2005 Network Configuration" tab
- Click on
"protocols for <SQL Instance name>
- Double
click on "TCP/IP on right side
- Select
"IP Addresses" tab
- Scroll
down to "IPALL"
- Change
"TCP Port" to the port you decided to use.
Recommended is:
- First
Instance 1434
- Second Instance 1435
- Press
'OK'
- Close
"SQL Server Configuration Manager"
- Restart
the DB node
- Once the
DB node, remove also the dynamic ports and restart the SQL
Services. Specially 'SQL Browser'.
1. Hardware
