Monday, March 19, 2012

Does MSDE listen on 1433 by default?

Does a default installation of MSDE listen for connections on TCP/IP port
1433 by default or do I need to explicitly turn the TCP/IP listener on using
svrnetcn.exe?
(I'm using W2kR4 (v5.00.2195) and MSDE v8.000.761)
hi,
sparky62 wrote:
> Does a default installation of MSDE listen for connections on TCP/IP
> port 1433 by default or do I need to explicitly turn the TCP/IP
> listener on using svrnetcn.exe?
> (I'm using W2kR4 (v5.00.2195) and MSDE v8.000.761)
if network protocols have been enabled at install time
(DISABLENETWORKPROTOCOLS=0 parameter) TCP/IP port 1433 is assigned by
default to a default instance, where named instances use by default
dynamically assigned port, and thus UDP 1434 is needed to..
The SQL Server Resolution Service, which operates on UDP port 1434, provides
a way for clients to query for the appropriate network endpoints to use for
a particular SQL Server instance... this handshake is provided at connection
time via MDAC stack (MDAC must be at 2.6 level at least) , the SQL Server
Resolution Service queries the SQL Server instance for the port it is
listening to and transfer that info to the client redirecting the dialog to
that port...
if a static port has been assigned, the SQL Server Resolution Service is no
longer needed but you have to define an Alias pointing to the server on the
correct port on each remote client..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

No comments:

Post a Comment