Re: Connecting Dynamic Port from Client

From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 09/29/04 

Date: Wed, 29 Sep 2004 17:06:01 +0200

hi,
"Atchy" <bakedmind@hotmail.com> ha scritto nel messaggio
news:uMd$YBjpEHA.2636@TK2MSFTNGP09.phx.gbl
>
> I found the MS article:
> 823938 :How to use static and dynamic port allocation in SQL Server
> 2000 http://support.microsoft.com/default.aspx?kbid=823938
> --------------------------------------------------------------------------
--------
> Dynamic port allocation
> Only named instances of SQL Server can use the dynamic port allocation
> process
> --------------------------------------------------------------------------
--------
>
> That's mean normal instance(NOT named instance) of MSDE can not use
> dynamic ports allocation?
> I tried and failed in normal instance network
> And I tried named instance network and that's successed...
>
> The conclusion:
> Normal instance of MSDE is not supported dymamic port allocation
>
> That's really!?

why should it be else??
dynamic redirection has been established as more instances (up to 16) can be
installed on the same server and, if the DEFAULT instance is listening on
TCP 1433, there should be a way to set connections without requiring an
Alias to be defined on the client side (each client) and defining a static
alternate port server side...
this is no more a viable solution on Windows XP sp2 as the Windows Firewall
requires a better security policy, so static redirection is again the way to
go, opening the desired port and defining Alias on the client side 

-- 
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm        http://italy.mvps.org
DbaMgr2k ver 0.9.1  -  DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Relevant Pages

  • Failed to Start SQL Server Resource
    ... updates and patches on the nodes and tried to move the second SQL Instance ... the SQL Server Resource failed to start and moved back ... The Cluster Management Extension for SQL Server sqsrvres failed to login to ... how the dynamic port allocation worked in detail? ...
    (microsoft.public.sqlserver.clustering)
  • Re: Using SSL with named instance
    ... I can connect to the named instance using Enterprise Manager but not through ... > I created the certificate on the target SQL Server. ... > CA' on client. ... Then I enabled 'Force PRotocol Encryption' on ...
    (microsoft.public.sqlserver.security)
  • Named Instance
    ... I couldn't connect to named instance in my client machine... ... error messange.. ... SQL Server Doesn't exist or Access denied. ...
    (microsoft.public.sqlserver.clients)
  • highly appreciated.
    ... I am trying to connect the named instance from my client computer... ... easily connect the default instance of my remote machine but when I tried to ... connect through named instance it gave me an error that SQL Server doesn't ...
    (microsoft.public.sqlserver.clients)
  • Re: Named Instance
    ... >I couldn't connect to named instance in my client machine... ... > error messange.. ... SQL Server Doesn't exist or Access denied. ...
    (microsoft.public.sqlserver.clients)