Post reply

Is there a way to change the IP address of SQL Server which is locally hosted and is not on cluster?

  • September 3, 2014 at 7:19 am

    #290309

    Hi All,

    I am asking about a virtual IP for SQL Server, is there a way we can assign a different IP to SQL Server other than the server's(host) IP address? like the same what we do in a clustered env.

    Thanks.

  • September 3, 2014 at 10:57 am

    #1742916

    Yes you can add extra IP addresses for SQL server to listen on, you either stack them on the same NIC or have separate NICs

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • September 3, 2014 at 9:37 pm

    #1743065

    How can I do it? Can you please help me with the steps as in what exactly needs to be changed in the configuration manager.

  • September 4, 2014 at 5:32 am

    #1743146

    do you plan to use separate NICs or one NIC?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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