Seeing slq on cluster on more than one network -- sql server clustering

Simon JJJJ
2/22/2004 2:29:29 PM

We have a pair (active passive) of SQL 2003 running in a cluster. The
problem is that the virtual SQL server only appears on one of the two
networks we have running. The settings under SQL IP in the cluster
manager only allows you to select one network.

I want to be able to access the virtual server from both networks (one
is a monitoring network).

Any ideas?

*** Sent via Developersdex http://www.developersdex.com ***

Bjornmob
2/24/2004 11:00:36 PM

Haven't tried it but...

Add an IP resource to the SQL Server cluster group and
make the SQL Server resource dependent upon it.

BTW: I think SQL Server setup handles this for you. It is
possible to add more than one IP address to the virtual
server.

HTH

Bjorn
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clustering

sql server clustering : Seeing slq on cluster on more than one network