Client port for SQL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I'm running a vb.net Windows application that communicates with a SQL Server
using SQLClient.SQLConnection.

How do I specify the port on the client that should be used for this
communication? I would like to have a setting in the application that will
allow the user to change this as desired.

I have a customer that would like the client application to use port 80 so
they can avoid some firewall issues. Are there any issues with doing this?

Thank you for your assistance,
Mark Lauser - Crimson Software
 
Hi Mark,

You need to do two things:

1. Use the Server Network Utility for SQL Server (on the server) and change
it to port 80.

2. In your code, change your connection string so that it connects to the
IP,port. For example: 127.0.0.0,80. Now your code will talk to SQL Server
over port 80.

Remember though that all apps talking to this server will need to be changed
to port 80. Good luck! Ken.
 
Thank you Ken,

That would probably work all right for the one customer, except other
customers use the same server on port 1433.

Isn't there any way to make the client system use port 80 on its side, but
still let the server use 1433 on its side? I guess I am not understanding
how ports work.

80 is also the TCP port for a web site on this server (very low volume).
Can both the web site and SQL Server use the same port? Will this cause any
problems/conflicts?

Thank you,
Mark Lauser - Crimson Software
 
Back
Top