Tuesday, February 14, 2012

Can 2 SQL servers on domain use same port number?

This might seem very obvious... but my knowledge of SQL 2000 is limited.
We got in a company to install and configure a 2nd SQL server with some new software onto our domain. They have told us that the 2nd SQL server must use a different port number to the 1st SQL server. Is this the case? It makes no sense to me and is now causing a problem with another application we wanted to put onto the SQL server as well. This program has the port address hard coded, and can not be changed which currently means we can't use it. (The 1st server also has a similar piece of software on it which also can't cope with a different port number, so I can't just switch them and the old server can't cope with anything more being added to it.)
If they have to have different port numbers, why? I thought traffic went by IP address and then port numbers.
Many thanks
E TaylorYou need different port numbers if you are on the same machine.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
.
"KESW" <KESW@.discussions.microsoft.com> wrote in message
news:EC1BE223-9D7B-4BC9-8004-414E3079D162@.microsoft.com...
This might seem very obvious... but my knowledge of SQL 2000 is limited.
We got in a company to install and configure a 2nd SQL server with some new
software onto our domain. They have told us that the 2nd SQL server must
use a different port number to the 1st SQL server. Is this the case? It
makes no sense to me and is now causing a problem with another application
we wanted to put onto the SQL server as well. This program has the port
address hard coded, and can not be changed which currently means we can't
use it. (The 1st server also has a similar piece of software on it which
also can't cope with a different port number, so I can't just switch them
and the old server can't cope with anything more being added to it.)
If they have to have different port numbers, why? I thought traffic went by
IP address and then port numbers.
Many thanks
E Taylor|||Yep.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
.
"KESW" <KESW@.discussions.microsoft.com> wrote in message
news:9735F449-B89B-4224-A71E-447D02225336@.microsoft.com...
So if they are on separate servers, they can have the same port number?
"Tom Moreau" wrote:
> You need different port numbers if you are on the same machine.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
> ..
> "KESW" <KESW@.discussions.microsoft.com> wrote in message
> news:EC1BE223-9D7B-4BC9-8004-414E3079D162@.microsoft.com...
> This might seem very obvious... but my knowledge of SQL 2000 is limited.
> We got in a company to install and configure a 2nd SQL server with some
new
> software onto our domain. They have told us that the 2nd SQL server must
> use a different port number to the 1st SQL server. Is this the case? It
> makes no sense to me and is now causing a problem with another application
> we wanted to put onto the SQL server as well. This program has the port
> address hard coded, and can not be changed which currently means we can't
> use it. (The 1st server also has a similar piece of software on it which
> also can't cope with a different port number, so I can't just switch them
> and the old server can't cope with anything more being added to it.)
> If they have to have different port numbers, why? I thought traffic went
by
> IP address and then port numbers.
> Many thanks
> E Taylor
>

No comments:

Post a Comment