Re: SQL Server multiple instance problem

All instances of SQL Server will bind to all IP addresses at service
startup. This cannot be changed. The default instance will grab port 1433.
Other instances will randomly bind to an available port. UDP Port 1434 is
used to resolve port numbers and names in SQL Server multi-instance
installations. You can use the Server Network Utility to force an instance
to use a particular port.

Geoff N. Hiten
Microsoft SQL Server MVP


"John" <john@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:O1SQ$PSXFHA.228@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
>
>
> I have created 2 instances in SQL server on a windows 2000 server over a
> Public IP. The 1st instance is assigned the PUBLIC IP and can be accessed
> over a remote location.
>
> Whereas the 2nd instance cannot be accessed over the public IP.
>
>
>
> Now I want to change and assign the Public IP to the second instance, so
> that the 2nd instance can be connected from a remote location over the
> Internet.
>
> Thanks in advance
> John Mendonca
>
>


.

Relevant Pages

  • Re: ADP problems after SQL 2005 Upgrade
    ... Use the SQL Server Configuration Manager to create aliases; ... each port can be associated only with a single instance. ... Sylvain Lafontaine, ing. ...
    (microsoft.public.access.adp.sqlserver)
  • [NT] Microsoft SQL Server 2000 Unauthenticated System Compromise
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Microsoft's database server SQL Server 2000 exhibits two buffer-overrun ... clients connecting to TCP port 1433 or both. ... This message is a single byte packet, ...
    (Securiteam)
  • Re: Do SqlServer 2000 & SqlServer 2005 co-exist
    ... Either SQL Server 2000 or SQL Server 2005. ... So you have to move one of them to another port. ... You could allow an program exception in your firewall instead of a port number exception. ... I understand that you can connect to SQL 2000 named instance on the local ...
    (microsoft.public.sqlserver.setup)
  • Re: IIS, SQL 2000 & XPs Firewall
    ... Only one instance of SQL Server can use TCP port 1434. ... You may find it easier to use SQL Server Configuration Manager ... 2008 will be a named instance ... you will have to open those as exceptions in the firewall. ...
    (microsoft.public.sqlserver.connect)
  • Re: Is there any way to prevent hacker trying to guess sa password?
    ... and port 1433 will not be open. ... If someone can crash SQL Server by connecting to port 1433, ... You don't need multiple security experts. ...
    (microsoft.public.sqlserver.security)