Sunday, February 19, 2012

Clustering installation issue

I'm trying to install SQL 2000 on a newly clustered Win2000 system.

I'm getting the following error:
The drive chosen for the program files installation path, C:, is not valid on all nodes of the cluster. Choose another drive to install the program files.

I've read Microsoft's explanation of the error, and that the one server can't access the C: drive of the other server if file and print sharing isn't setup correctly. However...

I'm logged on as Administrator, and have full control of both machines.
I'm telling the SQL install to use the administrator account.
If I go to start->run-> and type \\serverB\C$ the share opens just fine.
I've also check the registry entries that MS suggests: HKey_LocalMachine\Software\Microsoft\Windows\Curre ntVersion and make sure that the value for CommonFilesDir and ProgramFilesDir is the same on both the nodes. They're the same

I am trying to install the data files within the same group as the quorom drive, but that should just give me a warning (and it does) and shouldn't be this problem. I'm just trying to install to the system drive (C:) which certainly exists on both machines.

I've seen a couple other posts about this, but no solutions. Any help would be great.

Thanks,
MattReview this http://support.microsoft.com/default.aspx?scid=kb;[LN];Q279642] to take care of further installation.|||Satya,

I tried the link that you provided, but got to a Microsoft page that said that page no longer exists.

If it's the KB article:
Microsoft Knowledge Base Article - 279642

I have already gone through that without any luck. But if it's something else, I'd be happy to try it.

Also, I have since been able to get the installation to work if instead of using the C: drive, I use the drive dedicated to the page file. Obviously, this isn't something I'd want to do, but hopefully it provides more information that might help someone figure out what my issue is.

Thanks,
matt|||You cn install the program files to the C:\ drive, but all data has to be installed on a shared drive. Are you selecting custom install with Data going to a shared drive?|||Further help from here (http://www.sql-server-performance.com/wndows2000_clustering_install_main.asp)

HTH|||Well, I have no idea what this issue was, but to get around it you can:

Install SQL Server locally to one of the nodes of the cluster.
Be sure to put the data files on a drive that is part of the cluster.
Then upgrade the local instance to a clustered instance.

All worked for me, using that strange process.

No comments:

Post a Comment