ACtive-ACtive Clustering SQL server 2005

Question

ACtive-ACtive Clustering SQL server 2005

forsqlserver

SSCoach

Points: 18902
More actions
October 4, 2009 at 11:11 pm

#215977

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

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

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

forsqlserver SSCoach Points: 18902 More actions · Answer 1

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

Vishal Singh SSCertifiable Points: 5830 More actions · Answer 2

This LINK could be a help for you?

-Forum Etiquette: How to post Performance Problems[/url]

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

forsqlserver SSCoach Points: 18902 More actions · Answer 3

Thanks Vishal...

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

Thanks

Vishal Singh SSCertifiable Points: 5830 More actions · Answer 4

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[/url]

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

forsqlserver SSCoach Points: 18902 More actions · Answer 5

forsqlserver

SSCoach

Points: 18902

October 5, 2009 at 1:28 am

#1061576

Working

Thanks

Vishal Singh SSCertifiable Points: 5830 More actions · Answer 6

guptaajay1985 (10/5/2009)
Working

Great! So happy to hear that.

-Forum Etiquette: How to post Performance Problems[/url]

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

padmasoft SSC Rookie Points: 27 More actions · Answer 7

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.

Leo.Miller SSChampion Points: 13051 More actions · Answer 8

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

Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.