Multiple instances of MSSQL and IP addresses

Hi.
Not sure if this is the correct newsgroup (could not find another suitable g
roup), and if
not please redirect me to the proper one...
We're running multiple instances of MSSQL 2000 on a server. This is done to
easily
incorporate client DBs into our testing operations. The problem is that all
instances
share the same IP address (but use different ports). So we can access each i
nstance
separately as we want, but we would like it better that each instance is lis
tening on its
own IP address.
But we can't find a way to change the IP address a named instance is listeni
ng on.
Anybody know how to do this?
NOTE: we prefer not to be using Clustering and/or Virtual Server. This is a
single
development server used for testing client scenario's...
Tx.Hi
Does this mean you have a network card for each instance? In which case you
may be able to disable the ports you don't want to use in the network
configurations IP Filtering options. Alternatively you could do it at the
firewall/router.
John
"Arjan de Haan" wrote:

> Hi.
> Not sure if this is the correct newsgroup (could not find another suitable
group), and if
> not please redirect me to the proper one...
> We're running multiple instances of MSSQL 2000 on a server. This is done
to easily
> incorporate client DBs into our testing operations. The problem is that al
l instances
> share the same IP address (but use different ports). So we can access each
instance
> separately as we want, but we would like it better that each instance is l
istening on its
> own IP address.
> But we can't find a way to change the IP address a named instance is liste
ning on.
> Anybody know how to do this?
> NOTE: we prefer not to be using Clustering and/or Virtual Server. This is
a single
> development server used for testing client scenario's...
> Tx.
>
>
>|||"John Bell" <jbellnewsposts@.h0tmail.com> wrote in message
news:BFD4DDB0-FAC1-4E24-9C33-999F9AAF902E@.microsoft.com...
> Hi
> Does this mean you have a network card for each instance? In which case yo
u
> may be able to disable the ports you don't want to use in the network
> configurations IP Filtering options. Alternatively you could do it at the
> firewall/router.
> John
>
No, the server has (currently) just one NIC.
To better clarify things:
The server running the multiple instances of MSSQL can be reached through a
number of IP
addresses. Is it possible, either through changing settings in Windows 2000
(which is
running on the server) or by changing some settings of each MSSQL instance t
o have each
instance receive packets directed to a specific IP address. For example,
3 running instances of MSSQL
SQL_A, 'binds' to IP xxx.xxx.0.1, port 1140,
SQL_B, 'binds' to IP xxx.xxx.0.2, port 1140, and
SQL_C, 'binds' to IP xxx.xxx.0.3, port 1140.
Currently all instances of MSSQL can be reached through the same IP address
but by using
different port numbers, like this:
3 running instances of MSSQL
SQL_A, 'binds' to IP xxx.xxx.0.1, port 1140,
SQL_B, 'binds' to IP xxx.xxx.0.1, port 1143, and
SQL_C, 'binds' to IP xxx.xxx.0.1, port 1146.
We prefer the first setup described. Is this possible without resorting to v
irtual servers
and clustering?
Thanks for your help.
...Arjan...|||Hi
I don't think there is a way to bind to a specific IP address, you are
limited to blocking ports.
How are these IP addresses assigned?
John|||"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1115966034.360116.66440@.o13g2000cwo.googlegroups.com...
> Hi
> I don't think there is a way to bind to a specific IP address, you are
> limited to blocking ports.
> How are these IP addresses assigned?
>
John,
the server running the MSSQL instances has been assigned multiple IP address
es (visible
thru Network properties / TCP IP properties / Advanced properties). This was
apparently
done on the server itself.
Just checked but it is indeed reachable under all its assigned IP addresses.
...Arjan...|||Hi
I think you can only do this at the firewall then.
John|||"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1115985697.036330.184570@.g14g2000cwa.googlegroups.com...
> Hi
> I think you can only do this at the firewall then.
>
In another newsgroup they suggested I need multiple NICs in the server for t
his, and even
then they were not sure it could be done.
Thanks anyway for answering.
...Arjan...|||Hi
See http://support.microsoft.com/defaul...kb;en-us;816792
which states
Note When you select this check box, you enable filtering for all
adaptors, but you configure the filters individually for each adaptor.
The same filters do not apply to all adaptors.
Which is what I pointed you to in the first post. As it is at adaptor
level having multiple IP addresses for the one adapter will not work.
John