dbTalk Databases Forums  

ADO, TCP/IP Ports & Firewalls

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients


Discuss ADO, TCP/IP Ports & Firewalls in the microsoft.public.sqlserver.clients forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tristan Leask
 
Posts: n/a

Default ADO, TCP/IP Ports & Firewalls - 02-26-2009 , 10:48 AM






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


Reply With Quote
  #2  
Old   
Mohit K. Gupta
 
Posts: n/a

Default RE: ADO, TCP/IP Ports & Firewalls - 02-26-2009 , 10:52 AM






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:

Quote:
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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.