Post reply

SQL 2005 Cluster Problem

  • September 27, 2012 at 3:05 am

    #282127

    Hi Guys,

    I'm wondering if anyone can help me, i really don't wanto to reinstall one ofe the nodes in the cluster...

    The problem is that in one of the nodes everything that its related to "generic services" don't start...and because of that situation i was forced to run everything in only one of the nodes...

    i checked for a solution nothing came by except this one:

    http://g1w0134.austin.hp.com/bizsupport/TechSupport/document.jsp?lang=en&cc=us&taskId=110&prodSeriesId=4142975&prodTypeId=18964&objectID=c03088216

    Thanks/Regards

  • September 27, 2012 at 7:05 am

    #1542859

    Hi,

    It's not clear what your issues is.

    If your cluster isn't allocating resources correctly then I don't think you are posting in the right place.

    Make sure your cluster is working properly.

    Test swapping resources.

    Make sure there are no hardware problems.

    Check your windows event logs.

    If the cluster logs information, try to find that.

    Goodluck.


    For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

    "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort

  • September 27, 2012 at 7:10 am

    #1542861

    Hi,

    the Node1, doesn't start "Full Text" and "Analisys services", if i change everything to the Node2 everything cames UP... in the link that i posted the error that is occuring its completly explained...but in this case its in a SQL 2005 Cluster environment...

  • September 27, 2012 at 7:32 am

    #1542888

    I'm using a 2Node Active/Active.

  • September 27, 2012 at 8:41 am

    #1542943

    The error its only when we change the SQL1 instance to the node1...like is in the attachment..

  • September 27, 2012 at 8:52 am

    #1542952

    Maybe an obvious question, but have you tried rebooting node1?

    Unfortunately the link doesn't work for me.

    Goodluck.


    For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

    "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort

  • September 27, 2012 at 9:39 am

    #1542973

    Yes, i restarted both nodes, then i tried to restart one at a time, and at node1 full text and analisys services don't start, but if I change the "aplication" to node2 everything starts...

  • September 28, 2012 at 12:54 pm

    #1543594

    check the event logs for further info

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • October 1, 2012 at 3:55 am

    #1543883

    Thanks to all, i've solved the problem, it was permission issues..

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply