TCP-Portnummern bei mehreren SQL Server Instanzen auf einem Computer

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hallo,



Im SQL Server Configuration Manager gibt es zwar die Möglichkeit dynamische Ports zu aktivieren, jedoch sollen diese nicht verwendet
werden, wenn eine Firewall aktiv ist.



"Dynamic Ports

If enabled, the default instance of the Microsoft SQL Server Database Engine listens on TCP port 1433. Named instances of the SQL
Server Database Engine and SQL Server Mobile are configured for dynamic ports, which means they select an available port when the
SQL Server service is started. When connecting to a named instance through a firewall, configure the Database Engine to listen on a
specific port, so that the appropriate port can be opened in the firewall."



Wenn man eine Anwendung schreibt die eine Named Instance verwendet, die man weitergeben möchte, ohne zu wissen welche SQL Server
Instanzen schon auf dem Zielcomputer vorhanden sind. Wenn diese Named Instance auch Remotezugriffe zulassen soll, welche Portnummer
würdet ihr fest vergeben?



Grüsse,

Markus






.

Relevant Pages

  • Re: Connecting to an instance in a cluster
    ... "Geoff N. Hiten" wrote: ... you cannot reuse port numbers. ... Microsoft SQL Server MVP ... That is the port you have to open on the firewall. ...
    (microsoft.public.sqlserver.clustering)
  • Re: IIS, SQL 2000 & XPs Firewall
    ... You may find it easier to use SQL Server Configuration Manager ... 2008 will be a named instance ... Queries to the Data Engine must go to the port that SQL Server is ... you will have to open those as exceptions in the firewall. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Server 2008 remote connection problem
    ... Hitchhiker’s Guide to Visual Studio and SQL Server ... default instance of the SQL Server Database Engine listens on TCP port 1433", ... > I was trying to establish a remote connection to SQL Server 2008 from ... The server is running the XP firewall. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL server connection problem
    ... no firewall is installed? ... Also i have check that port 1433 is not ... Will SQL server only connect to this ... > to configure the firewall to permit connections to SQL Server. ...
    (comp.databases.ms-sqlserver)
  • Port Assignments : Multiple Instances : SSPI context issue
    ... A SQL server has the initial instance installed as a named instance ... Internet app is using 1433 to talk to the named instance. ... the install utility for the app does not work against ... By default it too is assigned port 1433!! ...
    (microsoft.public.sqlserver.server)