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

• Ashif Shaikh

  Default port

  Points: 1445

  More actions

  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.

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  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" 😉

• Ashif Shaikh

  Default port

  Points: 1445

  More actions

  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.

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  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" 😉