Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Multiple Listeners not running

2 posts in Windows NT Last posting was on 2000-08-08 19:42:45.0Z
david.brough Posted on 2000-08-08 15:02:44.0Z
From: david.brough@nygard.com
Date: Tue, 8 Aug 2000 11:02:44 -0400
Newsgroups: sybase.public.sqlserver.nt
Subject: Multiple Listeners not running
Message-ID: <71CD8C04D5C6DF740052A5D385256935.0052A5E185256935@webforums>
Lines: 16
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:1759
Article PK: 1089234

I am trying to configure Sql Server 11.0.3 to listen on 2 TCP/IP addresses
at the same time. The server has 2 nic cards each with a unique IP address.
When I configure the sql.ini file to listen on either the first or second
card and restart the server, it works perfectly on whatever address I have
it configured and can be accessed.

When I try to put 2 master entries in the sql.ini file for that server,
each with it's own IP address, the connection fails when attempting to
access the second IP address. I have tried it with using the same port
number and using different port numbers. When the 2 addresses are in the
interfaces file, the first will still work.

Has anyone set up this kind of configuration and got it to work. I would be
interested in any tips that you can give.

Thx, Dave


Bret Halford Posted on 2000-08-08 19:42:45.0Z
Message-ID: <399062B5.AACE0BE5@sybase.com>
Date: Tue, 08 Aug 2000 13:42:45 -0600
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en,ja
MIME-Version: 1.0
Subject: Re: Multiple Listeners not running
References: <71CD8C04D5C6DF740052A5D385256935.0052A5E185256935@webforums>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 25
NNTP-Posting-Host: bret-pc.sybase.com 157.133.80.211
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1757
Article PK: 1089228

Hi David,

Might help if you post your sql.ini file that shows your two entries.

-bret

david.brough@nygard.com wrote:

> I am trying to configure Sql Server 11.0.3 to listen on 2 TCP/IP addresses
> at the same time. The server has 2 nic cards each with a unique IP address.
> When I configure the sql.ini file to listen on either the first or second
> card and restart the server, it works perfectly on whatever address I have
> it configured and can be accessed.
>
> When I try to put 2 master entries in the sql.ini file for that server,
> each with it's own IP address, the connection fails when attempting to
> access the second IP address. I have tried it with using the same port
> number and using different port numbers. When the 2 addresses are in the
> interfaces file, the first will still work.
>
> Has anyone set up this kind of configuration and got it to work. I would be
> interested in any tips that you can give.
>
> Thx, Dave