Multiple Instances with Different IP Addresses and Same Port Number in SQL Server

• SQLEngine

  SSCommitted

  Points: 1633

  More actions

  February 8, 2010 at 7:13 am

  #1115465

  Are they created automatically for 2008 cluster?

• johnc.lockhart

  Grasshopper

  Points: 24

  More actions

  May 12, 2010 at 9:20 am

  #1166310

  I am having the same issue. I've tried/set all the options as oulined, but still am not able to connect to the server directly (eg:dbservername), only by using servername\dbserversname, or by setting up a local alias (dbservername=servername\dbservername), or a third way (using dbartisan for example, servername:port number).

  Is there anything else that could be an issue?

• Jared

  SSC Guru

  Points: 61793

  More actions

  July 9, 2013 at 2:33 pm

  #1630982

  I know this is an old discussion, but it came up when I was googling the interwebs for info on this.

  1. You need to understand DNS.

  2. You need to configure your server's network config correctly; i.e. do not register automatically with DNS Server

  3. Delete all A records from DNS and re-enter as static

  4. Disable listen all in your nework protocols

  5. Set ip's accordingly

  6. Set dynamic ports to nothing; i.e. delete anything there. Otherwise it will use it. 0 is not blank, it is "find something"

  Should all work.

  Jared
  CE - Microsoft

• Kevin Eckart

  SSC-Addicted

  Points: 481

  More actions

  August 1, 2013 at 8:42 am

  #1637816

  We have a server with 3 instances of SQL Server running, each running on it's own IP and port 1433.

  I've created a blog post outlining how it was done.

  http://kevine323.blogspot.com/2013/08/setting-up-aliases-on-sql-server-with.html