March 27, 2008 at 3:44 pm
Hello,
I am using MS Virtual Server and wanted to configure sql 2005 clustering.
My configurations are:
1. DC
2. Node1
3. Node2
DC, Node1, and Node2 are in the domain.
1. Bring up the DC
2. Bring up the Node1
3. Bring up the Cluster Administrator and started the clustering configuration.
4. I run into serveral errors.
Services won't start:
Error 1067: The process terminated unexpectedly.
Could not start the Cluster Service service on local computer.
Errors on Clustering Config:
The cluster node is down
The node is already a member of a cluster but the cluster services is not running. This node will not be configured at this time
Can someone help and advise.
Thank you.
Edwin
March 27, 2008 at 4:31 pm
Hi Edwin,
You could try running clusprep.exe
It runs some checks to see if you are properly configured for clustering.
I wonder if maybe you don't have a problem with shared disk configuration. Only one node can access the shared drive at any given time. Any chance you had Node2 powered on with access to the quorum?
Clustering newbie myself...
Todd Carrier
MCITP - Database Administrator (SQL 2008)
MCSE: Data Platform (SQL 2012)
March 27, 2008 at 4:49 pm
Can you describe your setup between the two nodes? Shared disk, network, etc.?
K. Brian Kelley
@kbriankelley
March 28, 2008 at 2:57 am
http://blogs.msdn.com/blakhani/
I have written 3 parts blog for same topic.
March 28, 2008 at 8:07 am
For everyone's convenience:
How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 1)
How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 2)
How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 3)
K. Brian Kelley
@kbriankelley
March 28, 2008 at 12:06 pm
THank you All for kind replied.
My Node1 and Node2 is configured:
SCSI 0 Fixed disk "Quarum"
SCSI 1 Fixed disk "Sqldata"
SCSI 2 Fixed disk "sqllog"
Both configured on TCP/IP.
Both Node1 and Node2 cluster services are running on Domain account "clusterAdmin".
March 28, 2008 at 12:21 pm
My MS Virtual Server 2005 is running in Window Vista Businesss.
March 28, 2008 at 12:36 pm
Does the account specified for the cluster service account have administrative rights to both nodes? Have you verified you can ping both nodes from each other?
K. Brian Kelley
@kbriankelley
March 28, 2008 at 12:37 pm
Hello Brian,
My clustering errors are occurred when I am in Part #3 on step 6 on Balmukund article's links.
Thanks for the help.
Edwin
March 28, 2008 at 12:54 pm
Yes, the clusterAdmin has the admin right on both nodes. The clusterAdmin is a member of Local Groups Administrator on both machine.
When I started the Clusrer services, I got the errors.
March 29, 2008 at 11:44 am
please post last 10 lines of ClCfgSrv.log
[font="Verdana"]--www.sqlvillage.com[/size][/font]
March 29, 2008 at 10:53 pm
Where can I find the CICfgSrv.log.?
DC, or Node1 or Node2 servers.
Thanks,
Edwin
March 31, 2008 at 9:47 am
It's going to be found at:
%systemroot%\System32\Logfiles\Cluster\Clcfgsrv.log
on one of your two cluster nodes.
K. Brian Kelley
@kbriankelley
April 1, 2008 at 9:01 am
Hi Brian,
I run into problems to copy the files from Virtual Server to Host.
Still trying to figure it out.
Thanks for your help.
Regards,
Edwin
April 1, 2008 at 9:12 am
An easy way is to open the log file, select all, copy, and then open up notepad on the host, paste.
K. Brian Kelley
@kbriankelley
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply