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.

Two IP addresses

3 posts in ,  Windows NT Administration Last posting was on 2001-04-11 15:47:30.0Z
Alexander Mitchenko Posted on 2001-04-10 12:43:20.0Z
From: "Alexander Mitchenko" <alex@alexm.carrier.kiev.ua>
Subject: Two IP addresses
Date: Tue, 10 Apr 2001 15:43:20 +0300
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <vkzRE4bwAHA.157@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.administration,sybase.public.sqlserver.nt
NNTP-Posting-Host: 194.44.107.132
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.administration:796 sybase.public.sqlserver.nt:247
Article PK: 1063031

Hi All!

Can anybody give me advise how i should configure Sybase SQL Server to
listen for two IP addresses.
My server is running on Windows NT server machine which participate in two
separate network branches,
e.g. one real "outside brunch" with IP 193.190.190.1 which is acceptable
from Internet and second "local brunch"
with IP 192.168.1.1 in which SQL server currently lives.

Should I add new section in SQL.ini file for the outside network brunch (in
this case can i use real ip address in SQL.ini) or there is some other way.

Thanks in advance

Alexander Mitchenko
Kiev, Ukraine


Jim Egan Posted on 2001-04-10 16:01:45.0Z
From: Jim Egan <dbaguru@eganomics.com>
Subject: Re: Two IP addresses
Date: Tue, 10 Apr 2001 10:01:45 -0600
Message-ID: <MPG.153cdc58d7ec981e98b271@forums.sybase.com>
References: <vkzRE4bwAHA.157@forums.sybase.com>
Reply-To: eganjp@compuserve.com
X-Newsreader: MicroPlanet Gravity v2.30
Newsgroups: sybase.public.sqlserver.administration,sybase.public.sqlserver.nt
Lines: 57
NNTP-Posting-Host: jpe650.sybase.com 157.133.56.43
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.administration:792 sybase.public.sqlserver.nt:246
Article PK: 1063028

Adaptive Server can accommodate multiple networks. This allows ASE to listen for clients
over multiple network interfaces. You must add an entry for each network interface to the
interfaces file.

Follow these steps to configure multiple network listeners:

1. Define a unique host name for each network interface in your operating system's host
database.

2. In your interfaces file, use a text editor or DSEDIT, add copies of the "master" line
for your Adaptive Server, one for each additional interface you want the server to listen
on.

3. Include a unique host name on each line to configure a network handler for each network
interface.

4.Port numbers within the interface need not be the same, but they can be. They fall under
the same rules for naming and numeric range as the primary network interface.

Following is an example interfaces file for an Adaptive Server with two network interfaces,
each connected to a different network. The server host machine is connected to a TCP/IP
network, on which it is called serv_corpnet, and a DECnet network, on which it is called
serv_engnet.

# PRODUCTION server with two network listeners
PRODUCTION<tab>3<tab>3<newline>
master tcp ether serv_corpnet 6464
master decnet ether serv_engnet 150
query tcp ether zeppo 6464

The following is an example interfaces file for an Adaptive Server with two network
interfaces. The server host machine is known as serv_corpnet on the corporate network and
serv_engnet on the engineering network.

# PRODUCTION server with two network listeners
PRODUCTION<tab>3<tab>3<newline>
master tcp ether serv_corpnet 4559
master tcp ether serv_engnet 5479
query tcp ether serv_corpnet 4559
(Interface files may look different depending on the platform. Use DSEDIT to get it
right.)
The next time Adaptive Server is restarted, it spawns a network handler process for each
"master" line in the entry that corresponds to the server's DSLISTEN value. Connections
made on each interface will be handled equally, as peers.

--
Jim Egan [TeamSybase]
Senior Consultant
Sybase Professional Services

Get your free subscription to PowerTimes at http://www.powertimes.com


Alexander Mitchenko Posted on 2001-04-11 15:47:30.0Z
From: "Alexander Mitchenko" <alex@alexm.carrier.kiev.ua>
References: <vkzRE4bwAHA.157@forums.sybase.com> <MPG.153cdc58d7ec981e98b271@forums.sybase.com>
Subject: Re: Two IP addresses
Date: Wed, 11 Apr 2001 18:47:30 +0300
Lines: 75
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <9uv2gDqwAHA.165@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.administration,sybase.public.sqlserver.nt
NNTP-Posting-Host: 194.44.107.132
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.administration:782 sybase.public.sqlserver.nt:245
Article PK: 1063017

Thanks a lot Jim!

"Jim Egan" <dbaguru@eganomics.com> wrote in message
news:MPG.153cdc58d7ec981e98b271@forums.sybase.com...
> Adaptive Server can accommodate multiple networks. This allows ASE to
listen for clients
> over multiple network interfaces. You must add an entry for each network
interface to the
> interfaces file.
>
> Follow these steps to configure multiple network listeners:
>
> 1. Define a unique host name for each network interface in your operating
system's host
> database.
>
> 2. In your interfaces file, use a text editor or DSEDIT, add copies of
the "master" line
> for your Adaptive Server, one for each additional interface you want the
server to listen
> on.
>
> 3. Include a unique host name on each line to configure a network handler
for each network
> interface.
>
> 4.Port numbers within the interface need not be the same, but they can be.
They fall under
> the same rules for naming and numeric range as the primary network
interface.
>
> Following is an example interfaces file for an Adaptive Server with two
network interfaces,
> each connected to a different network. The server host machine is
connected to a TCP/IP
> network, on which it is called serv_corpnet, and a DECnet network, on
which it is called
> serv_engnet.
>
> # PRODUCTION server with two network listeners
> PRODUCTION<tab>3<tab>3<newline>
> master tcp ether serv_corpnet 6464
> master decnet ether serv_engnet 150
> query tcp ether zeppo 6464
>
> The following is an example interfaces file for an Adaptive Server with
two network
> interfaces. The server host machine is known as serv_corpnet on the
corporate network and
> serv_engnet on the engineering network.
>
> # PRODUCTION server with two network listeners
> PRODUCTION<tab>3<tab>3<newline>
> master tcp ether serv_corpnet 4559
> master tcp ether serv_engnet 5479
> query tcp ether serv_corpnet 4559
> (Interface files may look different depending on the platform. Use DSEDIT
to get it
> right.)
> The next time Adaptive Server is restarted, it spawns a network handler
process for each
> "master" line in the entry that corresponds to the server's DSLISTEN
value. Connections
> made on each interface will be handled equally, as peers.
>
> --
> Jim Egan [TeamSybase]
> Senior Consultant
> Sybase Professional Services
>
> Get your free subscription to PowerTimes at http://www.powertimes.com