SQL Server Software on cluster: local drive other than C:?

[Steve]

I'm trying to build a new cluster with SQL Server 2K Enterprise on
Windows 2003 server. When I run the install, I tell it to put the
program files on the D: (local) drive and the data/log files on shared
drives. However, after the installation is complete, almost all the
files go in the C: drive in \program files\Microsoft SQL Server, rather
than the D: drive (it does create a few files on D:). We've experienced
this on more than one server build.

Anyone know any way around this?

Post answers publicly, please, or email to
steven.wechsler(at)mtvstaff.com (the posting email address is hosed).

Thanks,

Steve

[Simon Hayes]

I don't know much about clustering myself, however this KB article
notes that in SQL 2000, only databases are failed over, not binaries,
so in order for setup to install the binaries, "you must ensure that
each node has a local drive letter in common with all the other nodes
in the cluster". Is it possible that only some nodes have a D: drive?

http://support.microsoft.com/default...b;en-us;243218

In any case, it would probably be worth giving Microsoft a call - I
guess that if you have the requirement and the resources to implement
clustering, then the cost of a support call is negligible (if you don't
already have a general support agreement). And if the issue is caused
by a bug in the product, then it's free anyway.

Simon