Post reply

Changing Server IP Address After Installing SQL 2012

  • January 28, 2016 at 4:48 am

    #311139

    Here is the scenario we have:

    1. Installed SQL Server

    2. Changes the server IP addresses (to move to a less secure LAN for development)

    We found that after we did this we could connect with the new IP address BUT the IP Addresses tab under the TCP/IP Protocol Name for "Protocols for MSSQLSERVER" still has old IP address. Do we have to change this manually? What are the considerations?

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

  • January 28, 2016 at 7:58 am

    #1854960

    Remove the settings from that address and configure IpAll.

    You should be fine.

    -- Gianluca Sartori

  • January 28, 2016 at 9:11 am

    #1855000

    Thanks a lot.

    So the old IP address remains there, correct?

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

  • January 28, 2016 at 9:21 am

    #1855003

    It shouldn't, but it won't do any harm if you're listening on all addresses.

    -- Gianluca Sartori

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply