al4629740
asked on
Instructions to Unblock Firewall for Administrator
If my VB6 program requires access to an SQL database through port 1433, then my guess is that I need to have port 1433 opened at every site my program is used...correct? If the port is blocked, what instructions should I give the network administrator?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
What is a good port range to open?
depends ..
I'd open only the necessary ports, for web it is 80 and 443, usually.
I'd open only the necessary ports, for web it is 80 and 443, usually.
ASKER
But I need to have another port for my application.
You can pick just about anything that is not in common use (anything below 1024 is considered "common") but it also depends on what is in use already. If you app really needs network access to a SQL server, just pick a port that is not already used. You can Google a list of common ports.
Better may be to provide a way for the CLIENT to specify what port to use in an options dialog, so each client can specify what THEY actually use. Set the default as the default 1433, but give each individual install a way to change the port to match what they NEED.
You will never be able to pick a port that is perfect for everybody.
Better may be to provide a way for the CLIENT to specify what port to use in an options dialog, so each client can specify what THEY actually use. Set the default as the default 1433, but give each individual install a way to change the port to match what they NEED.
You will never be able to pick a port that is perfect for everybody.
allow TCP on port 1433 in- and outbound, at least initiated from outbound (assuming that the SQL server is inbound)
But I'd never open that port (see previous comment:)