TCP/IP File sharing port number 1

[dr486]

Hi all,

We have a DTS package attempting to import data from an excel spreadsheet on a remote machine through a firewall.

Does anyone know which port\protocol we would need to open on the firewall to allow this?

eg:
[Srv1]->[Firewall]->[Srv2]
Srv1 executes DTS and needs to import xls from Srv2

 

[Spirit]

Whats the name of the package? Is it custom?

Stick a port monitor on the pc in question and then you'll know exactly what ports it requires.

http://www.protect-me.com/?from=prog_aports

Iain

 

[LawnBoy]

MS-SQL uses port 1433.

 

[kbing]

You can find the port # out a couple of ways:

While you have the application running and connected to your server:

a) run netstat on the server and find the name of the workstation running the client software. It will show the port #.

b) run TCPview from Sysinternals.com. This will also show TCP ports

http://www.sysinternals.com/Utilities/TcpView.html