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

Does Identity columns... create an index by default

Hi,
If I create an identity column on a sql server table.... does "sql server"
create an index too...
Or do I have to create an index explicitly.
Thanks
Nalaka"Nalaka" <nalaka12@.nospam.nospam> wrote in message
news:OXPawNnGIHA.4476@.TK2MSFTNGP06.phx.gbl...
> Hi,
> If I create an identity column on a sql server table.... does "sql
> server" create an index too...
> Or do I have to create an index explicitly.
> Thanks
> Nalaka
>
>
No it doesn't. Assuming, you want the column to be unique you should create
a PRIMARY KEY or UNIQUE constraint on the column. A constraint does
automatically create an index.
--
David Portas|||Thanks David
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:O23KLQnGIHA.5980@.TK2MSFTNGP04.phx.gbl...
> "Nalaka" <nalaka12@.nospam.nospam> wrote in message
> news:OXPawNnGIHA.4476@.TK2MSFTNGP06.phx.gbl...
>> Hi,
>> If I create an identity column on a sql server table.... does "sql
>> server" create an index too...
>> Or do I have to create an index explicitly.
>> Thanks
>> Nalaka
>>
>>
> No it doesn't. Assuming, you want the column to be unique you should
> create a PRIMARY KEY or UNIQUE constraint on the column. A constraint does
> automatically create an index.
> --
> David Portas
>