Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Installation of SQL Server 2005 on cluster returns error


Installation of SQL Server 2005 on cluster returns error

Author
Message
Patti Johnson
Patti Johnson
SSC Veteran
SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)

Group: General Forum Members
Points: 261 Visits: 949
I looked and the resources are online.
Patti Johnson
Patti Johnson
SSC Veteran
SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)

Group: General Forum Members
Points: 261 Visits: 949
Can someone to confirm whether you have to install "EVERYTHING" on the D: drive? I thought with clustering, it installs on the second server for you behind the scenes. You just point the resource "which is the database" on the D: drive. That is what fails over back and forth between the 2 servers.
sqlbuddy123
sqlbuddy123
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1212 Visits: 2243
Hi Patricia,

Usually the binaries are installed on the local drives of each node, but the datafiles (.mdf and .ldf) have to be placed on the SAN. If the datafiles are installed on the local drives like D, during the failover the failed over instance cannot function on the new node.

Thank You,

Best Regards,
SQLBuddy
Patti Johnson
Patti Johnson
SSC Veteran
SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)

Group: General Forum Members
Points: 261 Visits: 949
Thank you that is what I thought and that is what I am doing. I still can't get this to install. I searched the internet and there is some info that I may not have the rights as an administrator. But the Windows SA's have confirmed that I do. So I don't understand.
mtassin
mtassin
SSCarpal Tunnel
SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)SSCarpal Tunnel (4.1K reputation)

Group: General Forum Members
Points: 4101 Visits: 72512
Patricia Johnson (8/12/2009)
I looked and the resources are online.



I just want to confirm that all the resources are online?

In my case when I went to do the install, the resources I intended to use were online, but there was a different cluster resource group with several offline storage resources. Until I brought them online as well, I could not install, and was given the same error message.



--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
sqlbuddy123
sqlbuddy123
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1212 Visits: 2243
Hi Patrica,

Suppose you have a 3 node cluster with Node A, Node B and Node C. Suppose you are doing the installation on node A, then there are 2 places in the installation process where you have to assign Drive letters to the SQL Server files

1. During the FEATURE SELECTION SCREEN, you have to specify the folder location for the SQL Server binaries. The location you specify must be on the local disks.

On the feature selection screen,

Click “Browse” to select directory “SQLBinariesPath\Program Files\Microsoft SQL Server”.

Note that SQLBinariesPath must be either C or D drives. Suppose if you choose D , then the same drive D should also be available on Node B and Node C as their own local drive. Other the failover clustering doesn't work.

2. On the CLUSTER GROUP SELECTION screen , first you have choose a dedicated cluster group (Which is not being Used by any other sql server instances) for the sql server instance you are installing and then

Select DataDrive from available drives in cluster group.

DataDrive can be any drive on the SAN. It must be visible to the other nodes in the cluster. Also LOCAL DRIVES should NOT be used for placing the Databases. If the databases are placed on the local drive like D, the failover clustering will fail.

Thank You,

Best Regards,
SQLBuddy
Patti Johnson
Patti Johnson
SSC Veteran
SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)

Group: General Forum Members
Points: 261 Visits: 949
Hey Guys,

I wanted to let you know what I found...

On the passive node, for some reason the C$ share was missing. We are not sure how that happened because it was needed for cluster services to be installed.

We added the share back and rebooted. Then restarted the installation and I got past the problem.

Thank you for all your time with helping me.

I've got another problem so I will start a new post. The installation failed again for some other weird reason. I'm fishing thru the logs to find what it might be.

Thanks again.
Patti
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search