RE: ADO, TCP/IP Ports & Firewalls

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Random port?

For SQL Server the port is 1433, yes it can be different if the server the
instance resides on has multiple instances. In which case on the server side
you can force port configurations.

Far as I know you don't have to worry about ports from client side ... I
have used ADO for many years. And only port I ever gotten anyone to open is
1433.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"Tristan Leask" wrote:

Hi everyone,

Ok, basically I am in the process of trying to sort my app out with unicode
support. A good way of doing this would be to use ADO. However, I have been
told by the powers that be, we originally used ADO but had to remove it
because the connection back when using ADO uses a random port from a range.
This isnt acceptable because of customers wanting to secure servers on both
inbound and outbound ports and they are not willing to open up a port range.

Can this be restricted at all, or do I have to abandon the idea of ADO???

Thanks

.

Relevant Pages

  • RE: Some technical errors
    ... If the SMTP server is not running on port 25 TCP it is not a public ... Manager - Computer Assurance Services BDO Chartered Accountants & ...
    (Security-Basics)
  • Re: SRV RRs support in Internet Explorer?
    ... The port number could be implicit (i.e. ... At any point in time, a server could fail ... can't effectively LB or backup because NSs cache the records for the TTL ... I still don't see how SRV records would help backup or LB. ...
    (microsoft.public.win2000.dns)
  • Re: Still cant connect to RWW or OWA remotely
    ... I get 'cannot find server or dns error' on both ... TCP [port number]> to open the ports. ... As for error messages when I fail to access RWW with the laptop, ... network, no connection seems possible. ...
    (microsoft.public.windows.server.sbs)
  • Re: cannot send mail from Windows mail
    ... When a username/password combination doesn't work in Windows Mail, ... I mean I dont use it but as outgoing address for my ISP account. ... youir username and password are correct for your mail server". ... Ask your home ISP if they support SMTP on a port other than 25. ...
    (microsoft.public.windows.vista.mail)
  • Re: How to trigger server to reattempt printer connection
    ... The spooler does not log any SNMP data. ... Best practices and known issues when you install Windows Server 2003 Service ... Before restarting the spooler next time, create a new port name to the ... This does not happen often, but when it does, it seems to stay offline ...
    (microsoft.public.windows.server.general)