SQLSERVER Clustering

[Anu]

Hi Guys,

I am installing sqlserver 7.0 in cluster server.
When I start with Installing the MSDTC and give the IP Address
of the Virtual server, It is giving message:

IP Address is in use.

I couldn't able to continue the installation further

Kindly advice me asap.

Thanks in advance,
Anu

[Tim]

Anu,

Take a look at the microsoft recommended instructions (if you haven't already)
I used them and everything worked fine. Good luck !

http://support.microsoft.com/support/sql/content/70papers/70clstr.asp

Tim


------------
Anu at 1/24/01 1:52:02 PM

Thanks Ray. I will try this.
Anu



------------
Ray Miao at 1/24/01 12:42:50 PM

You need 2 more ip addresses for msdtc and virtual sql server.


------------
Anu at 1/24/01 10:39:10 AM

Hi Guys,

I am installing sqlserver 7.0 in cluster server.
When I start with Installing the MSDTC and give the IP Address
of the Virtual server, It is giving message:

IP Address is in use.

I couldn't able to continue the installation further

Kindly advice me asap.

Thanks in advance,
Anu

[Mark Kemble]

Anu,

You are going to need up 7 IP addresses, depending on the type of clustering (active/active, active/passive) you plan to implement. Here's a list of the IP's you'll need for an active/active cluster (the active/passive set-up maybe the same, I don't know):

One for the Cluster Group
One for each server box (total of two)
One for each virtual SQL Server (two)
Two generic (internal) IP's so each cluster resource can continually check each other's "heart beat."

Also, Tim is right, download the Microsoft Cluster white paper if you haven't done so already. I can't imagine trying to install the cluster without it. Good luck . . .

Mark

------------
Tim at 1/25/01 6:07:39 AM

Anu,

Take a look at the microsoft recommended instructions (if you haven't already)
I used them and everything worked fine. Good luck !

http://support.microsoft.com/support/sql/content/70papers/70clstr.asp

Tim


------------
Anu at 1/24/01 1:52:02 PM

Thanks Ray. I will try this.
Anu



------------
Ray Miao at 1/24/01 12:42:50 PM

You need 2 more ip addresses for msdtc and virtual sql server.


------------
Anu at 1/24/01 10:39:10 AM

Hi Guys,

I am installing sqlserver 7.0 in cluster server.
When I start with Installing the MSDTC and give the IP Address
of the Virtual server, It is giving message:

IP Address is in use.

I couldn't able to continue the installation further

Kindly advice me asap.

Thanks in advance,
Anu

[Anu]

Hi Guys,

I have 4 questions as this is the first time I am going to install.

First:
======
I have 4 drives namely

F: Tempdb
G: Log
H: Index
I: Data

I am going to install the sqlserver in I drive. So the master.dat,msdb_data.dat,msdb_log.dat and model.dat will be in I drive.

If I create new database can I able to create database (selecting I drive) and log (selecting G drive)

Second:
=======

Do I need to install Windows option pack. Is it a must. We r not going to use IIS. We have a seperate server for IIS.

Third:
======

After Installing Sqlserver 7.0 service pack 1
I have to setup the Sql Cluster Service.

I have a doubt. If we need to install one more service pack after sometime, do I need to set up SQL cluster service.

Fourth:
=======
As we have select Active/Passive, Is it Ok if I install everything including service pack and run the cluster service in the Primary node and then after completing everything I install sql server Admin. utilities to Secondary node's local drive.



Kindly advice me asap.
Thanks in advance.
Anu






------------
Mark Kemble at 1/25/01 9:11:10 AM

Anu,

You are going to need up 7 IP addresses, depending on the type of clustering (active/active, active/passive) you plan to implement. Here's a list of the IP's you'll need for an active/active cluster (the active/passive set-up maybe the same, I don't know):

One for the Cluster Group
One for each server box (total of two)
One for each virtual SQL Server (two)
Two generic (internal) IP's so each cluster resource can continually check each other's "heart beat."

Also, Tim is right, download the Microsoft Cluster white paper if you haven't done so already. I can't imagine trying to install the cluster without it. Good luck . . .

Mark

------------
Tim at 1/25/01 6:07:39 AM

Anu,

Take a look at the microsoft recommended instructions (if you haven't already)
I used them and everything worked fine. Good luck !

http://support.microsoft.com/support/sql/content/70papers/70clstr.asp

Tim


------------
Anu at 1/24/01 1:52:02 PM

Thanks Ray. I will try this.
Anu



------------
Ray Miao at 1/24/01 12:42:50 PM

You need 2 more ip addresses for msdtc and virtual sql server.


------------
Anu at 1/24/01 10:39:10 AM

Hi Guys,

I am installing sqlserver 7.0 in cluster server.
When I start with Installing the MSDTC and give the IP Address
of the Virtual server, It is giving message:

IP Address is in use.

I couldn't able to continue the installation further

Kindly advice me asap.

Thanks in advance,
Anu

[Peter Karhatsu]

Couple of quick answers.

Do ALL service packs, NT and SQL BEFORE you cluster! Do the same on the passive node (NT only in your case).

Tempdb can go on the Data drive, Similar access methods.(Should be a RAID 0+1) Minimum of 10 disks if possible.

Log Drives should be mirrored.

Ther Quorom and the MSSQL bin and other data files, I would put on your F: drive.

You do not need Option Pack. That goes on the IIS/MTS server.

At this point in time I would really consider doing a total 2000 install.

You will probably regret it within a year if you don't....

Good Luck

Pete Karhatsu


------------
Anu at 1/25/01 10:15:05 AM


Hi Guys,

I have 4 questions as this is the first time I am going to install.

First:
======
I have 4 drives namely

F: Tempdb
G: Log
H: Index
I: Data

I am going to install the sqlserver in I drive. So the master.dat,msdb_data.dat,msdb_log.dat and model.dat will be in I drive.

If I create new database can I able to create database (selecting I drive) and log (selecting G drive)

Second:
=======

Do I need to install Windows option pack. Is it a must. We r not going to use IIS. We have a seperate server for IIS.

Third:
======

After Installing Sqlserver 7.0 service pack 1
I have to setup the Sql Cluster Service.

I have a doubt. If we need to install one more service pack after sometime, do I need to set up SQL cluster service.

Fourth:
=======
As we have select Active/Passive, Is it Ok if I install everything including service pack and run the cluster service in the Primary node and then after completing everything I install sql server Admin. utilities to Secondary node's local drive.



Kindly advice me asap.
Thanks in advance.
Anu






------------
Mark Kemble at 1/25/01 9:11:10 AM

Anu,

You are going to need up 7 IP addresses, depending on the type of clustering (active/active, active/passive) you plan to implement. Here's a list of the IP's you'll need for an active/active cluster (the active/passive set-up maybe the same, I don't know):

One for the Cluster Group
One for each server box (total of two)
One for each virtual SQL Server (two)
Two generic (internal) IP's so each cluster resource can continually check each other's "heart beat."

Also, Tim is right, download the Microsoft Cluster white paper if you haven't done so already. I can't imagine trying to install the cluster without it. Good luck . . .

Mark

------------
Tim at 1/25/01 6:07:39 AM

Anu,

Take a look at the microsoft recommended instructions (if you haven't already)
I used them and everything worked fine. Good luck !

http://support.microsoft.com/support/sql/content/70papers/70clstr.asp

Tim


------------
Anu at 1/24/01 1:52:02 PM

Thanks Ray. I will try this.
Anu



------------
Ray Miao at 1/24/01 12:42:50 PM

You need 2 more ip addresses for msdtc and virtual sql server.


------------
Anu at 1/24/01 10:39:10 AM

Hi Guys,

I am installing sqlserver 7.0 in cluster server.
When I start with Installing the MSDTC and give the IP Address
of the Virtual server, It is giving message:

IP Address is in use.

I couldn't able to continue the installation further

Kindly advice me asap.

Thanks in advance,
Anu

[Anu]

Hi Peter,

Thanks for ur immediate reply.
I appreciate that.

And one more doubt Why the log drives should be mirrored.
The log r is going to be in virtual server,
Is it good to be mirrored in the local drive of primary node/ secondary node.

Thanks,
Anu

------------
Peter Karhatsu at 1/25/01 10:44:56 AM

Couple of quick answers.

Do ALL service packs, NT and SQL BEFORE you cluster! Do the same on the passive node (NT only in your case).

Tempdb can go on the Data drive, Similar access methods.(Should be a RAID 0+1) Minimum of 10 disks if possible.

Log Drives should be mirrored.

Ther Quorom and the MSSQL bin and other data files, I would put on your F: drive.

You do not need Option Pack. That goes on the IIS/MTS server.

At this point in time I would really consider doing a total 2000 install.

You will probably regret it within a year if you don't....

Good Luck

Pete Karhatsu


------------
Anu at 1/25/01 10:15:05 AM


Hi Guys,

I have 4 questions as this is the first time I am going to install.

First:
======
I have 4 drives namely

F: Tempdb
G: Log
H: Index
I: Data

I am going to install the sqlserver in I drive. So the master.dat,msdb_data.dat,msdb_log.dat and model.dat will be in I drive.

If I create new database can I able to create database (selecting I drive) and log (selecting G drive)

Second:
=======

Do I need to install Windows option pack. Is it a must. We r not going to use IIS. We have a seperate server for IIS.

Third:
======

After Installing Sqlserver 7.0 service pack 1
I have to setup the Sql Cluster Service.

I have a doubt. If we need to install one more service pack after sometime, do I need to set up SQL cluster service.

Fourth:
=======
As we have select Active/Passive, Is it Ok if I install everything including service pack and run the cluster service in the Primary node and then after completing everything I install sql server Admin. utilities to Secondary node's local drive.



Kindly advice me asap.
Thanks in advance.
Anu






------------
Mark Kemble at 1/25/01 9:11:10 AM

Anu,

You are going to need up 7 IP addresses, depending on the type of clustering (active/active, active/passive) you plan to implement. Here's a list of the IP's you'll need for an active/active cluster (the active/passive set-up maybe the same, I don't know):

One for the Cluster Group
One for each server box (total of two)
One for each virtual SQL Server (two)
Two generic (internal) IP's so each cluster resource can continually check each other's "heart beat."

Also, Tim is right, download the Microsoft Cluster white paper if you haven't done so already. I can't imagine trying to install the cluster without it. Good luck . . .

Mark

------------
Tim at 1/25/01 6:07:39 AM

Anu,

Take a look at the microsoft recommended instructions (if you haven't already)
I used them and everything worked fine. Good luck !

http://support.microsoft.com/support/sql/content/70papers/70clstr.asp

Tim


------------
Anu at 1/24/01 1:52:02 PM

Thanks Ray. I will try this.
Anu



------------
Ray Miao at 1/24/01 12:42:50 PM

You need 2 more ip addresses for msdtc and virtual sql server.


------------
Anu at 1/24/01 10:39:10 AM

Hi Guys,

I am installing sqlserver 7.0 in cluster server.
When I start with Installing the MSDTC and give the IP Address
of the Virtual server, It is giving message:

IP Address is in use.

I couldn't able to continue the installation further

Kindly advice me asap.

Thanks in advance,
Anu