Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a 4-node SQL Server 2012 SP1 cluster, and under Network Configuration -> TCP/IP -> Protocol (tab), I am able to switch Listen All from Yes to No. However, when I hit OK (or Apply), I get the message:

Any changes made will be saved; however they will not take effect until the service is stopped and restarted.

OK, fine.

Now, if I re-open the TCP/IP properties, Listen All is back to Yes.
This happens even after I restart the SQL Server service, and it happens on all 4 instances.

I have checked the version of Configuration Manager - 2011.0110.2100.060. I've compared this with a (non clustered) SQL Server 2012 where I can flip the IP All field at whim, the versions are the same (as are the SQL Server versions, 11.0.3000.0 Build 7601).

I've also ensured that under IP Addresses, the one that I want to use has Enabled = Yes, all other IPs have Enabled = No.

Neither BOL nor Google have any useful information for me.

Has anyone seen this before?

share|improve this question

migrated from stackoverflow.com Feb 28 '14 at 8:56

This question came from our site for professional and enthusiast programmers.

Welcome to Stack Overflow! This is a question on professional server, networking, or related infrastructure administration. It should probably be moved to Server Fault. –  Danilo Piazzalunga Feb 13 '14 at 23:28
Why would it be there? This question is very specific to SQL Server. –  user1771538 Feb 14 '14 at 1:25
Your question is about administering SQL Server: moving your question to Server Fault will allow you to get better answwers. –  Danilo Piazzalunga Feb 14 '14 at 12:03

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.