June 30, 2012 at 5:42 am
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
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
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
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
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