Help Understanding Cluster config & SQL Virtual Server & Instance

Hello,

I am trying to setup a 2-node cluster on W2k3 and SQL 2005 in our lab.

In cluster Admin console, I have the following groups/resources:

For Node A:
Cluster Name: NodeA

Groups:
1. Cluster Group
IP Address: .....188.111
Network Name: HubNodeA
Physical Disk: Disk Q: This is the quorum drive. Q: drive.

2. MSDTC
IP Address: .....188.112
Network Name: HUBMSDTC
Physical Disk: Disk T: Just a logical drive on the SAN for SQL
data.
DTC: Distributed Transaction Coordinator

3. SQLA Group for Node-A
IP Address: .....188.118
Network Name: RAS040SQLA
3 Physical Disks: F: G: H: SAN drives for SQL Data, backups,
logs

When attempting to install a SQL instance to Node-A....
Named Instance: INST1
Virtual Server Name: RAS040SQLA. A DNS alias exists. I get the
following error: Virtual Server Name already exists on the network. Why
does this error get generated? How does the VSN relate to the Network name
in Cluster Admin?
Because of the error, I use RAS040RLSQLA as the VSN. This is accepted by
SQL setup program.
IP address: ......188.118: I get the error, "IP Address already in use.".
What causes this error? Is it because of the IP Address for group SQLA?
If I delete the IP Address resource from the Group SQLA, then this IP
Address will work.

So, I need to understand the relationship between the IP Address and Network
Name resources in Cluster Admin and the Virtual Server Name and IP Address
used to install a SQL instance.

Setting up groups and resources in Cluster Admin.

I need to setup Groups & resources in Cluster Admin. for the following:
1. For the SQL Instance
2. To cluster MSDTC
3. To cluster SQL SSAS
4. BizTalk Enterprise Single Sign-On

How should I configure these in the Cluster Admin, and when should I create
them?
In other words, what do I configure in Cluster Admin prior to running SQL
setup and what should be created after running SQL Setup? In SQL, I need the
following:
1. SQL Server Database Services
2. SQL failover cluster
3. Analysis Services
4. Analysis Server for failover cluster
5. Notification Services
6. Workstation components, BOL, Dev tools

Sorry to be long-winded but wanted to provide all the details.

TIA,
DetRich

Hi DetRich,

I beleive you may have created a Host (A) records for the virtual name.
Since there are DNS entries exists for the Ip and the name, it would have
popped up with "The name already exists" / "Ip address already in use"
warning messages..(maintening uniqueness in the domain)

And have a look at the link below, which may help...
http://support.microsoft.com/kb/257932

-Sharath

"DetRich" wrote:

> Hello,
>
> I am trying to setup a 2-node cluster on W2k3 and SQL 2005 in our lab.
>
> In cluster Admin console, I have the following groups/resources:
>
> For Node A:
> Cluster Name: NodeA
>
> Groups:
> 1. Cluster Group
> IP Address: .....188.111
> Network Name: HubNodeA
> Physical Disk: Disk Q: This is the quorum drive. Q: drive.
>
> 2. MSDTC
> IP Address: .....188.112
> Network Name: HUBMSDTC
> Physical Disk: Disk T: Just a logical drive on the SAN for SQL
> data.
> DTC: Distributed Transaction Coordinator
>
> 3. SQLA Group for Node-A
> IP Address: .....188.118
> Network Name: RAS040SQLA
> 3 Physical Disks: F: G: H: SAN drives for SQL Data, backups,
> logs
>
> When attempting to install a SQL instance to Node-A....
> Named Instance: INST1
> Virtual Server Name: RAS040SQLA. A DNS alias exists. I get the
> following error: Virtual Server Name already exists on the network. Why
> does this error get generated? How does the VSN relate to the Network name
> in Cluster Admin?
> Because of the error, I use RAS040RLSQLA as the VSN. This is accepted by
> SQL setup program.
> IP address: ......188.118: I get the error, "IP Address already in use.".
> What causes this error? Is it because of the IP Address for group SQLA?
> If I delete the IP Address resource from the Group SQLA, then this IP
> Address will work.
>
> So, I need to understand the relationship between the IP Address and Network
> Name resources in Cluster Admin and the Virtual Server Name and IP Address
> used to install a SQL instance.
>
> Setting up groups and resources in Cluster Admin.
>
> I need to setup Groups & resources in Cluster Admin. for the following:
> 1. For the SQL Instance
> 2. To cluster MSDTC
> 3. To cluster SQL SSAS
> 4. BizTalk Enterprise Single Sign-On
>
> How should I configure these in the Cluster Admin, and when should I create
> them?
> In other words, what do I configure in Cluster Admin prior to running SQL
> setup and what should be created after running SQL Setup? In SQL, I need the
> following:
> 1. SQL Server Database Services
> 2. SQL failover cluster
> 3. Analysis Services
> 4. Analysis Server for failover cluster
> 5. Notification Services
> 6. Workstation components, BOL, Dev tools
>
> Sorry to be long-winded but wanted to provide all the details.
>
> TIA,
> DetRich