Post reply

installing multiple instance on same IP address and port

  • June 30, 2012 at 5:42 am

    #271922

    Can i install multiple instance of SQL Server 2008 R2 on same IP Address with same port number say 1515 for all instances. Can anyone help me out with this issue. Installing multiple instances with same port number caused some problems in development zone. And i was forced to assign different port numbers for respective instances.

    Its just a doubt about using same port no. for multiple instances on same IP address.

    Can anyone help me out........:cool:

  • June 30, 2012 at 7:15 am

    #1507446

    Each instance requires its own unique port number. You can force each instance to use any port you wish but again they must be unique.

  • July 1, 2012 at 2:26 am

    #1507524

    To add further, the IP and port number must be a unique combination for the installed instances, the following would be valid

    Instance1 10.10.10.205 1433

    Instance2 10.10.10.205 1642

    Instance3 10.10.10.207 1433

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

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

  • July 2, 2012 at 4:52 am

    #1507676

    What sort of issue are you getting assigning different ports to each instance? So long as the SQL Browser service is running, the actual port each instance is on should be entirely transparent to the application--they'll connect to the SQL Browser, which will automatically redirect them to the appropriate port.

  • July 5, 2012 at 2:23 am

    #1508974

    Thanks a lot.

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

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