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 |
|
TwoBobBill
Starting Member
3 Posts |
 Posted - 2010-11-17 : 10:31:36
|
| Can someone confirm that all instances of SQL Server running on the same server run on separate ports.When we install one of our software products, we are normally doing it on the default instance running on port 1433. One of our consultants went to a customer who wanted it installing on a different instance. Our software isn't currently setup to connect to a database by using servername\instancename so I said to the consultant that the second instance should be running on a different port and as long as you have this in our configuration it should work.The customer was adamant that both instances of SQL were running on port 1433 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
TwoBobBill
Starting Member
3 Posts |
Posted - 2010-11-17 : 11:41:53
|
quote:
Originally posted by tkizer
You can check SQL Server Configuration Manager. You can also change the ports in there. Each instance will need to use a different port.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
Thanks for that. It was a few weeks ago now and they eventually moved the database to the default instance to get it working. The consultant is a bit unsure but I went through it with her today and it looks as though the default instance was port 1433 and the other instance was dynamic. It's just that she says they insisted that both ran on the same port. I told her at the time that i was led to believe all instances had different ports but they were having none of it |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
TwoBobBill
Starting Member
3 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQL Instance ports