dbTalk Databases Forums  

Re: SQL Install error

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Re: SQL Install error in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Scott
 
Posts: n/a

Default Re: SQL Install error - 07-21-2003 , 02:10 PM






I know. I have a separate drive array to be used as the
Quorum disk, and I'm still getting the same message. I've
tried moving the data disk into another group, and that
didn't help. Anything else I might try or that anyone can
think of?


Quote:
-----Original Message-----
Ahh. SQL 2000 wants a free cluster disk for the shared
information and
local space on the system disk for the binaries.
Installing SQL on the
cluster quorum disk is not advised.

--
Geoff N. Hiten
Senior Database Administrator
Careerbuilder.com




"Scott" <scott.kulpins (AT) sbt (DOT) siemens.com> wrote in message
news:df7dc147.0306130542.3c7bc42 (AT) posting (DOT) google.com...
The binaries being installed on the local (C drive is
what's
failing. It seems that because I have only one cluster
resource disk
(array) the quorum disk (a partition on the cluster
disk array) is
causing the problem for setup:

Microsoft Knowledge Base Article - 295337
BUG: Virtual Server Fails to Install into Group with
Local Quorum
The information in this article applies to:
Microsoft SQL Server 2000 Enterprise Edition
Microsoft SQL Server 2000 Enterprise Evaluation Edition

This article was previously published under Q295337
BUG #: 236314 (SHILOH_BUGS)
SYMPTOMS
When you install SQL Server 2000 Enterprise Edition, if
you select the
cluster group that contains the local quorum, when you
reach the path
selection screen and attempt to accept the default
values, the dialog
box does not accept the paths that you enter or allow
the installation
to continue.

In the example in this article, the default path for
both data and
binary is E:\Program Files\Microsoft SQL Server, where
E: is the
system disk.

The Setup allows you to change the data path to F: (the
quorum disk);
however, the setup does not accept a change of the
binary path on the
E: drive.

The installation shows that the drive is a valid
cluster disk
resource.
CAUSE
The local quorum resource has a private property that
shows the path
as:

E:\Windows\<Path Name

The Setup reads the E: drive and determines that the E:
drive is a
shared drive.
WORKAROUND
To work around this problem:
Create a new cluster resource group.
Move the local quorum resource into the new group you
created in step
1.
Re-run the setup.
The Setup program now allows you to specify the data
folder and
proceed.
STATUS
Microsoft has confirmed this to be a problem in SQL
Server 2000.
Last Reviewed: 9/4/2002
Keywords: kbbug KB295337



Apparently, I need a second resource (disk/array) for
the quorum disk.
(Which is obviously always a good idea, but this
cluster is being
built for testing purposes only, so $$ is the concern.)

Is there any other way around this?
















clivec (AT) online (DOT) microsoft.com (Clive Challinor [MSFT])
wrote in message
news:<obAR##XMDHA.2108 (AT) cpmsftngxa06 (DOT) phx.gbl>...
Hi Scott
To say that SQL must use the shared drives but in
SQL2000 applies to
the
data, it does not apply to the programs, quite the
opposite the binaries
must be installed to a local drive, the setup program
will then perform
a
remote install of SQL to all configured nodes. If you
try to select a
shared disk for the programs setup will reject the
selection. This is
very
different to previous versions of SQL (7.0/6.5) which
installed
everything
to the shared drives. Back to the problem the
following Q article may
help.

279642 PRB: SQL Server 2000 Virtual Server Setup
Error: "The Drive
Chosen
for
http://support.microsoft.com/?id=279642

Regards,
Clive Challinor [MSFT]
This posting is provided "AS IS" with no warranties,
and confers no
rights


.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.