Re: Error installing SQL 2005 on a cluster

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks for the help, but I've found an undocumented "feature" with SQL 2005
clustering. Setup will fail if you have any offline physical disk resources.
I had created an "Unused Drives" resource group to keep my unused physical
disk resources from becoming corrupted but hadn't brought them online. My
solution was to bring all physical disk resources online while running SQL
2005 setup. Keep in mind, it wasn't the SQL disk that was offline. It was a
physical disk resource that I planned to use later for something like
Exchange or file sharing. I hope this saves someone else a bottle or two of
Asprin!

Thanks again!
Shane

"Ray Schueler[MSFT]" wrote:

Setup scans all the cluster nodes to make sure there is at least 1 common
drive between all of them. On a 32bit cluster it's usually C or D. If all
your nodes have a C: drive in common then you should be fine. Look in the
SQLSetup_machinename_WI.log file for more information.

Thanks.


"CShane" wrote:

I'm not quite sure I understand your suggestion. The C:\Program Files\
folder is where I'm trying to install the software. If I can ever get past
feature selection, I will select the S: drive for data. However, the S:
drive resource is online and functioning correctly inside cluster
administrator. I can also write to it from the resource owner.

Thanks for any help!


"Rodney R. Fournier [MVP]" wrote:

You need the S now to install the SQL data, C for the bits.

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner


"CShane" <CShane@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:69BC9FF1-38C1-490A-BC6B-704D22B1A607@xxxxxxxxxxxxxxxx
C drives are local for both nodes. The S drive will eventually be the SQL
drive, although I am not able to get to that point in the installation to
specify the resource group yet, although it is online and functioning. Q
is
the quorum and it's working fine.


"Michael Hotek" wrote:

Which drive letters do you have on each node? Which ones are local disks
and which are in the shared array? Which disks are configured in the
cluster group you are specifying for the failover cluster instance?

--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other
person
or entity either by inference or direct reference.


"CShane" <CShane@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9314C7CC-067B-4732-9274-DC6BA28AC092@xxxxxxxxxxxxxxxx
I am installing SQL 2005 on a two node 2003 SP1 cluster and get an error
after selecting components and I have narrowed it down to Shared Tools.
The
error is:

"The drive specified cannot be used for program location. Program
files
must be installed on a valid local disk available on all cluster nodes.
The
valid values are"

The help icon gives a LinkID of 20467, but I can't find any info on
that.

I'm installing to C:\Program Files\Microsoft SQL Server, which the Data
Files feature seems happy to install to. If only Shared Tools wasn't a
required component!

Anyone run into this or know what can cause it?






.

Relevant Pages

  • Re: Issues creating a new failover cluster on the same server
    ... G:\Microsoft SQL Server\MSSQL.1 ... CHNSQL04 Cluster Group ... Drives: H and F ... Group, the MS DTC Group, and each of the SQL Server Instance Groups running ...
    (microsoft.public.sqlserver.clustering)
  • Re: N+1 Configuration
    ... Jasper Smith (SQL Server MVP) ... But looking in the cluster admin tool, ... mounting all other drives under that drive ...
    (microsoft.public.sqlserver.clustering)
  • RE: Questions about cluster fail over
    ... 318534 Best Practices for Drive-Letter Assignments on a Server Cluster ... Physical Diskand all the SQL resources that get installed by SQL. ... > Will the cluster fail over correctly with the X: and Z: drives residing ...
    (microsoft.public.windows.server.clustering)
  • Re: SQL 05 ENT Cluster: not enough disk space for data files
    ... X:\Microsoft SQL Server ... I did notice that for some reason my drives are accessible (not just ... visable) to both cluster nodes (and its an active passive, ... These is not enough disk space on the destination disk for the current ...
    (microsoft.public.sqlserver.clustering)
  • Re: N+1 Configuration
    ... different from using a drive letter, in which case the SQL Server resource ... The current cluster is Active/Passive. ... mounting all other drives under that drive letter). ...
    (microsoft.public.sqlserver.clustering)