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 all 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 listening on its
own IP address.
But we can't find a way to change the IP address a named instance is listening 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


Show quoteHide quote

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 to 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 virtual 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,

the server running the MSSQL instances has been assigned multiple IP addresses (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

In another newsgroup they suggested I need multiple NICs in the server for this, and even
then they were not sure it could be done.
Thanks anyway for answering.

....Arjan...

Hi

See http://support.microsoft.com/default.aspx?scid=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

Error converting data type nvarchar to int.
move records from table1 to table2 if does not exist in table3
Query Help
FIFO report
Performance Issues using Aggregate MAX function within a temp table