Change default port no.

Hi,
As we know,SQL server listens on port 1433 by default. Is there any
dependency between client and SQL server for this port number?I mean, how
will know the client that on which port the target SQL server listens?
Suppose I change this port number to 1533 and restarted the SQL server.Now I
tries to connect to SQL server from a client.What will happnen on client sid
e
while making connections related to this port number?
With rgdsYou will need to change the port the client looks for as well. Open the
client network utility and you will see a Properties button that will allow
you to set the TCP port that the client will use by default.
Andrew J. Kelly SQL MVP
"Rajendra" <Rajendra@.discussions.microsoft.com> wrote in message
news:3B2040E2-9C6A-4941-B442-AD8A265A4765@.microsoft.com...
> Hi,
> As we know,SQL server listens on port 1433 by default. Is there any
> dependency between client and SQL server for this port number?I mean, how
> will know the client that on which port the target SQL server listens?
> Suppose I change this port number to 1533 and restarted the SQL server.Now
> I
> tries to connect to SQL server from a client.What will happnen on client
> side
> while making connections related to this port number?
> With rgds|||Hi Andrew,
Thanx for the reply. But if I am right then I think there is no need to make
change on client side.Suppose, u r having two computers C1 and C2.C1 is
having SQL server installed and C2 does not. The C2 computer has only
required files to make connection from SQL server.Now, I change the default
port of C1 to 1533 from 1433. The C2 has a VB application and try to connect
from C1 SQL server database and and got success.I have checked this.Then
where is need to change the port on client side?
I just want to ask whether there is any dependency on changing default port
no C1 fro SQL server to C2?
Thanx and regards,
"Andrew J. Kelly" wrote:

> You will need to change the port the client looks for as well. Open the
> client network utility and you will see a Properties button that will allo
w
> you to set the TCP port that the client will use by default.
> --
> Andrew J. Kelly SQL MVP
>
> "Rajendra" <Rajendra@.discussions.microsoft.com> wrote in message
> news:3B2040E2-9C6A-4941-B442-AD8A265A4765@.microsoft.com...
>
>|||You must still have port 1434 open. SQL Server uses port 1434 to establish
connections with clients. They interrogate this port to find suitable Sql
Server hosts but the actual data is sent thru 1433 or what ever port you
changed it to. There is plenty of good information in BooksOnLine. You
might want to try starting here: "Net-Library, overview"
Andrew J. Kelly SQL MVP
"Rajendra" <Rajendra@.discussions.microsoft.com> wrote in message
news:15C84574-02D6-4BDD-8A90-A36530D22751@.microsoft.com...[vbcol=seagreen]
> Hi Andrew,
> Thanx for the reply. But if I am right then I think there is no need to
> make
> change on client side.Suppose, u r having two computers C1 and C2.C1 is
> having SQL server installed and C2 does not. The C2 computer has only
> required files to make connection from SQL server.Now, I change the
> default
> port of C1 to 1533 from 1433. The C2 has a VB application and try to
> connect
> from C1 SQL server database and and got success.I have checked this.Then
> where is need to change the port on client side?
> I just want to ask whether there is any dependency on changing default
> port
> no C1 fro SQL server to C2?
> Thanx and regards,
> "Andrew J. Kelly" wrote:
>