<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
Installation of SQL Server 2005 on cluster...
17 posts, Page 1 of 2
1
2
»»
Installation of SQL Server 2005 on cluster returns error
Rate Topic
Display Mode
Topic Options
Author
Message
Patti Johnson
Patti Johnson
Posted Wednesday, August 12, 2009 2:15 PM
SSC Veteran
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:54 PM
Points: 210,
Visits: 722
I am receiving this error message when I try to install SQL Server 2005 Std on a clustered server.
The drive specified cannot be used for program location. Program files must be installed on a valid disk available on all cluster nodes. The valid values are:
There are no drives listed. It is blank. I can't get around this error.
Does anyone know what I need to do to fix this?
Post #769660
DBA in Unit 7
DBA in Unit 7
Posted Wednesday, August 12, 2009 2:29 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, April 09, 2013 1:53 PM
Points: 195,
Visits: 1,056
Do all your nodes have the same local drive settings?
For example, you have local drives C and D on one node, and they should be present on all the other nodes too.
Post #769674
sqlbuddy123
sqlbuddy123
Posted Wednesday, August 12, 2009 2:36 PM
Right there with Babe
Group: General Forum Members
Last Login: Wednesday, March 13, 2013 11:49 AM
Points: 715,
Visits: 1,523
Hi Patricia,
AFAIK the program files must be installed on the local drive i.e usually C or D drives.
Thank You,
Best Regards,
SQLBuddy
Post #769680
Patti Johnson
Patti Johnson
Posted Wednesday, August 12, 2009 2:48 PM
SSC Veteran
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:54 PM
Points: 210,
Visits: 722
Yes they are. The D: drive is the clustered drive.
Post #769688
Adam Angelini
Adam Angelini
Posted Wednesday, August 12, 2009 2:54 PM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, May 16, 2013 10:08 AM
Points: 1,084,
Visits: 805
for the disk you want to install SQL on, be sure you can move the disk resource to all the nodes in your cluster using cluster administrator.
Post #769694
Patti Johnson
Patti Johnson
Posted Wednesday, August 12, 2009 2:58 PM
SSC Veteran
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:54 PM
Points: 210,
Visits: 722
Right now all I am trying to do is install on the C drive and it still doesn't work. I usually point the data files to the D: drive and that is where the database will reside.
Post #769699
Adam Angelini
Adam Angelini
Posted Wednesday, August 12, 2009 3:04 PM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, May 16, 2013 10:08 AM
Points: 1,084,
Visits: 805
you have to install SQL to a disk that on SAN storage that can be moved or "failed over" to any of the nodes. that way, if there is a hardware failure on nodeA, it moves those disks to the other node.
Post #769705
mtassin
mtassin
Posted Wednesday, August 12, 2009 3:04 PM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 9:05 PM
Points: 3,226,
Visits: 64,095
I remember seeing this...
Do you have any offline storage resources in your cluster groups? I had this exact problem when I had an offline disk that I had no intention to use. Bringing the storage resource online solved it for me.
--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #769707
Patti Johnson
Patti Johnson
Posted Wednesday, August 12, 2009 3:14 PM
SSC Veteran
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:54 PM
Points: 210,
Visits: 722
I will have to look at that. Right now the Windows SA's are looking at the server. I had this problem before and I don't remember what I did to resolve it. What is weird is there are no drive letters listed. They are blank. I am not sure what log to look at. Most of the logs have way to much information that you have to have a Dr's degree to understand them.
Post #769713
mtassin
mtassin
Posted Wednesday, August 12, 2009 3:19 PM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 9:05 PM
Points: 3,226,
Visits: 64,095
Patricia Johnson (8/12/2009)
I will have to look at that. Right now the Windows SA's are looking at the server. I had this problem before and I don't remember what I did to resolve it. What is weird is there are no drive letters listed.
That's what makes me point to an offline disk resource somewhere in the cluster. I had that problem before, and that's what literally caused it.
--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #769717
« Prev Topic
|
Next Topic »
17 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
