Groups | Blog | Home
all groups > sql server (microsoft) > june 2006 >

sql server (microsoft) : assign each instance by each IP


Racheal
6/22/2006 2:43:44 AM
Dear all,

Do you know how to assign each instance by each IP.

eg.

SQL/Instance1 = 192.168.0.2
SQL/Instance2 = 192.168.0.3
SQL/Instance3 = 192.168.0.4

Thank

Racheal
Jens
6/22/2006 2:55:02 AM
Hi,

use the SQL Configuration Manager and navigate to each instance.
Configure the TCP/IP protocol to make only those IPAdresses active that
you want to assign to an instance.

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---
AddThis Social Bookmark Button