ACtive-ACtive Clustering SQL server 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » ACtive-ACtive Clustering SQL server 2005

ACtive-ACtive Clustering SQL server 2005

Rate Topic

Display Mode

Topic Options

Author

Message

forsqlserver

Posted Sunday, October 04, 2009 11:11 PM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 12:12 PM
Points: 1,186, Visits: 1,857

ACtive-ACtive Clustering
SQL server 2005
One node is working but another is not working error in sql log is :

Error:TDSSNIClient initialization failed with error 0x32, status code 0x1c

Error in eventvwr is: SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

Thanks

Post #797652

forsqlserver

Posted Sunday, October 04, 2009 11:48 PM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 12:12 PM
Points: 1,186, Visits: 1,857

The Following errors are coming again and again in eventvwr:

1. The description for Event ID ( 17182 ) in Source ( MSSQL$DOPMAILDB1 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: 32, 1c.

2.The description for Event ID ( 17120 ) in Source ( MSSQL$DOPMAILDB1 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: FRunCM.

3. The description for Event ID ( 19019 ) in Source ( MSSQL$DOPMAILDB1 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: [sqsrvres] StartResourceService: Failed to start MSSQL$DOPMAILDB1 service. CurrentState: 1
.

Thanks

Post #797663

Vishal Singh

Posted Monday, October 05, 2009 12:32 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 12:30 AM
Points: 353, Visits: 487

This LINK could be a help for you?

-Forum Etiquette: How to post Performance Problems

-Forum Etiquette: How to post data/code to get the best help

Post #797679

forsqlserver

Posted Monday, October 05, 2009 1:21 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 12:12 PM
Points: 1,186, Visits: 1,857

Thanks Vishal...

I have changed the listen all property of Tcp/Ip to No.

Thanks

Post #797693

Vishal Singh

Posted Monday, October 05, 2009 1:24 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 12:30 AM
Points: 353, Visits: 487

guptaajay1985 (10/5/2009)

Thanks Vishal...

I have changed the listen all property of Tcp/Ip to No.

Okay, so is it now working or you are facing the same problem?

-Forum Etiquette: How to post Performance Problems

-Forum Etiquette: How to post data/code to get the best help

Post #797694

forsqlserver

Posted Monday, October 05, 2009 1:28 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 12:12 PM
Points: 1,186, Visits: 1,857

Working

Thanks

Post #797695

Vishal Singh

Posted Monday, October 05, 2009 1:30 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 12:30 AM
Points: 353, Visits: 487

guptaajay1985 (10/5/2009)

Working

Great! So happy to hear that.

-Forum Etiquette: How to post Performance Problems

-Forum Etiquette: How to post data/code to get the best help

Post #797696

padmasoft

Posted Monday, September 20, 2010 10:08 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, November 08, 2010 7:44 PM
Points: 1, Visits: 13

Hi Vishal
Can we configure for a 3-node cluster [N1, N2, N3] a sql instnace on N1 failing to N3 and an analysis server instance on N2 failing to N3.
I guess this a wierd solution. Some one was wanting to use this configuratuion. is it possible. Is it manadatory to have a sql instance on the same machines as the analysis server?
Thet syill need two licenses.
Why not use the three machines and use active-passive-passive configuration for the sql and analysis servers.

Post #989899

Leo.Miller

Posted Monday, September 20, 2010 10:32 PM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, June 10, 2013 10:06 PM
Points: 442, Visits: 1,304

To have more than 2 nodes in a SQL Cluster you need SQL Server Enterprise Edition.

You can definitly have it on it's own node. We have a client that has a dedicated Analysis Services server, with only those services required for Analysis Services installed. Since Analysis Services is cluster aware you should be able to have it on a node and configure this to fail over to another node on failure.

Cheers

Leo

Post #989906

« Prev Topic | Next Topic »

Permissions