By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,556 Members | 1,600 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,556 IT Pros & Developers. It's quick & easy.

Client port for SQL

P: n/a
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
Nov 21 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.

--
Ken Dopierala Jr.
For great ASP.Net web hosting try:
http://www.webhost4life.com/default.asp?refid=Spinlight
If you sign up under me and have problems, email me.

"Mark Lauser" <Ma**@CrimsonSoftware.NoSpam.com> wrote in message
news:8A**********************************@microsof t.com...
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

Nov 21 '05 #2

P: n/a
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

"Ken Dopierala Jr." wrote:
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.

--
Ken Dopierala Jr.
For great ASP.Net web hosting try:
http://www.webhost4life.com/default.asp?refid=Spinlight
If you sign up under me and have problems, email me.

"Mark Lauser" <Ma**@CrimsonSoftware.NoSpam.com> wrote in message
news:8A**********************************@microsof t.com...
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


Nov 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.