Changes in protocol settings on cluster

Question

Hi,

I have a Active Passive cluster setup. I would like to disable all network protocols except TCP/IP. Is there any risk?

And I think we can make the change in Each node's configuration manager, first passive node and do failover then on the other node, please correct me if I am wrong. Any article which explains this scenario.

Thanks,

Ashru

---

MCTS, http://asharafaliptb.wordpress.com

Answer 1

Named pipes & other protocols has it's own advantage/disadvantage -you know tcp/ip is the best and  Clustered SQL Server installations require the TCP/IP protocol,

I dont think so there is no harm for if we  disable other protocols,earlier in sql server 2000/2005 there was  some dependencies(I didnt remeber).

.

I havent done testing,but tcp/ip should be the good choice.

see-
https://technet.microsoft.com/en-us/library/ms187892(v=sql.105).aspx

Review Network, Port, and Firewall Considerations
https://msdn.microsoft.com/en-us/library/ms189910.aspx


Failover Cluster Troubleshooting
https://msdn.microsoft.com/en-in/library/ms189117.aspx

---

Regards, S_NO "_"

Answer 2

There is no harm if you enable named pipes and TCP/IP.

also,changes you need to do both the nodes, yes you can do passive later active.

dont forgot failover/failback to test the connections to sql & apps.

---

Regards, S_NO "_"

Answer 3

There is no issue in disabling Named Pipes.  Note that you cannot disable Shared Memory as this is always enabled and used by default for local connections.

---

Martin Cairney SQL Server MVP

Answer 4

There is no issue in disabling Named Pipes.  Note that you cannot disable Shared Memory as this is always enabled and used by default for local connections.

---

Martin Cairney SQL Server MVP

is this mandatory -in this scenario -consider I dont want to login where the db server exists rather accessing from the other server.

---

Regards, S_NO "_"

Answer 5

Kindly ignore.

---

Regards, S_NO "_"