November 17, 2003 at 11:44 am
can u Please give me a tip or clue on how to solve this problem:
Cluster resource 'SQL Server 7.0' failed.
Do you have any clues on how to solve this problem?
When I switch on both nodes, the cluster manager tool keeps on switching the resources from one node to another trying to start the SQL Server Agent 7.0 to no avail.
If u have any tips on this, I will be very greatful.
November 17, 2003 at 1:08 pm
Is this a windows 2000 cluster? More info on your setup would help us find an answer.
Thanks,
Wes
November 17, 2003 at 10:09 pm
yes it is a windows 2000 cluster. Its an Active-Passive cluster.
November 18, 2003 at 12:10 am
Check your cluster log and the sqlserver-log regarding what is going on and where it fails.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 18, 2003 at 6:07 am
Also make sure all the resources that belong to sql are in the sql cluster group i.e. disk or services that may not have been included.
Wes
November 18, 2003 at 6:43 am
quote:
Also make sure all the resources that belong to sql are in the sql cluster group i.e. disk or services that may not have been included.Failed To find anything suffiecient to help me solve this problem. Any of you ever come accross this problem??
Wes
November 18, 2003 at 6:45 am
quote:
quote:
Also make sure all the resources that belong to sql are in the sql cluster group i.e. disk or services that may not have been included.Failed To find anything suffiecient to help me solve this problem. Any of you ever come accross this problem??
Wes
Should mention that am a newbie to SQL Server, especially in a cluster env
Please help out!!!!
November 18, 2003 at 7:55 am
without looking at the cluster logs or eventlogs on the server there isn't much we on the board can do for you.
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply