SQL 2005 Cluster Problem

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » SQL 2005 Cluster Problem

SQL 2005 Cluster Problem

Rate Topic

Display Mode

Topic Options

Author

Message

joao.vieira 22693

Posted Thursday, September 27, 2012 3:05 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, October 01, 2012 3:54 AM
Points: 8, Visits: 13

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

Post #1365108

Dennis Post

Posted Thursday, September 27, 2012 7:05 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 1:50 AM
Points: 109, Visits: 288

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.
http://www.sqlservercentral.com/articles/Best+Practices/61537/

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

Post #1365220

joao.vieira 22693

Posted Thursday, September 27, 2012 7:10 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, October 01, 2012 3:54 AM
Points: 8, Visits: 13

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...

Post #1365223

joao.vieira 22693

Posted Thursday, September 27, 2012 7:32 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, October 01, 2012 3:54 AM
Points: 8, Visits: 13

I'm using a 2Node Active/Active.

Post #1365254

joao.vieira 22693

Posted Thursday, September 27, 2012 8:41 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, October 01, 2012 3:54 AM
Points: 8, Visits: 13

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

Post Attachments

errosql.jpg (11 views, 224.46 KB)

Post #1365313

Dennis Post

Posted Thursday, September 27, 2012 8:52 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 1:50 AM
Points: 109, Visits: 288

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

Unfortunately the link doesn't work for me.

Goodluck.

Post #1365323

joao.vieira 22693

Posted Thursday, September 27, 2012 9:39 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, October 01, 2012 3:54 AM
Points: 8, Visits: 13

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...

Post #1365352

Perry Whittle

Posted Friday, September 28, 2012 12:54 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 5:53 AM
Points: 5,204, Visits: 11,158

check the event logs for further info

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

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

Post #1366074

joao.vieira 22693

Posted Monday, October 01, 2012 3:55 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, October 01, 2012 3:54 AM
Points: 8, Visits: 13

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

Post #1366449

« Prev Topic | Next Topic »

Permissions