Re: Issues creating a new failover cluster on the same server

Anthony,

To answer some of the items you have pointed out we have the following setup.

We have two nodes
Chssq04a – active
Chssq04p – passive

For clarification: there are two groups with the prefixes: CHS and CHN

We have two cluster groups; chnsq04 group is the new cluster and where the
new sql instance is being installed. Both SQL instances are installed on the
active node, CHSSQ04A.

CHSSQ04 Group
Assigned nodes: Chssq04a and Chssq04p

CHNSQ04 Group
Assigned nodes: Chssq04a and Chssq04p

Each virtual instance is unique with its own disks, ip, network name, and
instance name.

CHSSQ04 Group
Drives: E, G, K, S, Z
Two file shares
SQL IP address (10.0.50.48)
SQL Network Name (vssql04)
SQL Server (CHSNextgen)
SQL server agent (CHSNextgen)
SQL Server Fulltext (CHSNextgen)

SQL 2005 is installed for this instance at
G:\Microsoft SQL Server\MSSQL.1


CHNSQL04 Cluster Group
Drives: H and F
The setup then created the following:
SQL IP address (10.0.50.68)
SQL Network name (chnvssql04)
SQL Server (CHNNextgen)
SQL server agent (CHNNextgen)
SQL Server Fulltext (CHNNextgen)

SQL 2005 is installed for this instance at
H:\Microsoft SQL Server\MSSQL.2

We are not sharing drives for each cluster group and instance, they have
their own drives, and this means that CHNSQL04 can not see drives that are
used by CHSSQL04 and visa versa.

What I think your going to tell me is that I can not have two SQL Cluster
groups on the same node because the SQL Browser is not cluster aware and thus
can not see both clusters running at the same time. This is why I can not
start my second cluster group and instance.

.

Relevant Pages

  • Re: custom path for data files
    ... to the cluster group, make SQL dependent on it, and use it for data or logs. ... I am about to install sql 2005 in a clustered scenario. ... drive you want to use for SQL Server from the Available Cluster Groups. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Issues creating a new failover cluster on the same server
    ... A computer can only belong to a single cluster at a time and is typically called a node when it is a cluster member. ... While it is possible to set up SQL to not use specific cluster nodes, that is almost never done on a two node cluster. ... Microsoft SQL Server MVP ... active node, CHSSQ04A. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Adding a node to MS Clustering
    ... If you have SQL installed in the cluster group, that is probably the basis of your problem. ... Microsoft SQL Server MVP ... Yes the new node was created successfully before the SQL installation. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server down
    ... Are the underlying resources online and just the applications offline? ... Senior SQL Infrastructure Consultant ... Cluster Group, SQL Server is down and SQL Cluster Agent is offline. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server down
    ... In the Cluster Console, Cluster Group is up and running but in ... Cluster Group, SQL Server is down and SQL Cluster Agent is offline. ...
    (microsoft.public.sqlserver.clustering)
Loading