Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Gyto
Posting Yak Master
144 Posts |
 Posted - 2010-06-22 : 10:12:41
|
| Hi there,We have a SQL 2005 server with a single instance using the default port number 1433. We need to add another instance to this server, so I assume this will need it's own port number.So here's the question....can I leave the existing instance using port 1433 and just add another instance using a different port number, or will I have to change the port number of the existing instance as well?I'm not too keen on updating God knows how many connection strings ;o)Thanks,Matt |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-06-25 : 02:26:07
|
| If you use dynamic ports , it will automatically set a new port number. The policy where I'm working currently is not to use port 1433Jack Vamvas--------------------http://www.ITjobfeed.com |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-06-25 : 03:25:51
|
| Yes, you can keep the existing default instance running on port 1433. But for all connections made to the new instance you will have to specify the port number or the the instance name in the format servername\instancename.- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
|
|
|
Gyto
Posting Yak Master
144 Posts |
Posted - 2010-06-28 : 04:28:19
|
| Thanks guys, after a bit of research I have also come to the conclusion that it is probably best not to use the default port number....I assume this can be easily changed? |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
|
|
|
|
|
Changing instance port numbers