none
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.

    Here is what I set

    SQL Config Mgr - Protocol

    SQL Config Mgr - 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??

    thanks,


    Bert Sirkin

    Thursday, May 16, 2013 11:39 AM

Answers

All replies