When SQL Server will use port 139 and 445?

[pctest]

According to my understanding, SQL Server will use port 139 and port 445 when it is listening on Named Pipes. However, I have never seen port 445 being used. I want to know under what situation SQL Server will use port 445 instead of port 139 and vice versa.


Thank you for any help.

 

[JayKusch]

You would use port 445 if you are running RPC over Named Pipes.

Thanks

J. Kusch

 

[pctest]

Hi Jay,

Thank you for the reply. What do you mean by "RPC over named pipes"?

When I register a SQL Server which is using Named Pipes on a client machine which has enabled Named Pipes and both server and client are either Windows 2000 or Windows XP, will the registering use port 445?

I have seen the following terms but don't quite understand them:

1. named pipes over netbios - Which network transport protocol is used?
2. named pipes over tcp/ip - I guess the network transport protocol used is TCP/IP.
3. netbios over tcp/ip
4. smb over tcp/ip

I know the following terms:

1. Named Pipes is a network library.
2. TCP/IP and NetBEUI are network transport protocols.

 

[JayKusch]

RPC = Remote Procedure Calls ...

Here are a couple of articles/links that will explain it further.

http://www.winnetmag.com/Article/ArticleID/14360/14360.html

http://www.databasejournal.com/features/mssql/article.php/3334851

Also take a look at BOL (Books OnLine) under the heading of "protocol". This will also explain these protocols.

Thanks

J. Kusch

 

[pctest]

Hi Jay,

If I understand correctly, RPC is something related to Multiprotocol not Named Pipes.

I have read the articles and they are great articles but they don't really explain the terms that I'm trying to understand or I didn't get it.


Thank you for your help.

 

[JayKusch]

It is the remote procedure call (RPC) components in Windows NT using named pipes as the transport.

Thanks

J. Kusch

 

[pctest]

Hi Jay,

Do you have an example of running RPC over Named Pipes so I can try it out and see whether port 445 will be used?

Is registering a SQL Server in the client's EM a RPC?

Thank you.

 

[JayKusch]

I do not have an example of this type of operation. Sorry!

Thanks

J. Kusch