Answered by:

SQL Server with multiple NICs/IPs - can't configure to listen on only one IP

Question

I have SQL Server Express running on a remote computer. There are 2 NICS on the remote computer with the IP addresses 10.10.10.6 and 10.10.10.7.

I tried configuring SQL Server NOT to listen on one of the IP addresses with SQL Configuration Manager. I set the "protocol" tab "Listen All" option to "NO" and made one of the IP addresses inactive. But after restarting
SQL Server, it defaults back to listening on BOTH IP addresses.

The reason I want to do this is because from a remote computer, I never know which IP address SQL Server will be listening on - If I try to connect to 10.10.10.6, sometimes it works, but sometimes it doesn't. When it doesn't, it always works with 10.10.10.7
- and visa versa.

Any ideas why I can't disable SQL Server from listening on both IP addresses??