Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Application fails on cluster failover Expand / Collapse
Author
Message
Posted Friday, June 21, 2013 8:04 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 10:12 AM
Points: 110, Visits: 501
Hi everyone

I had a problem with one of the Application/service in my cluster.

Initially 4 of the 5 applications are recited on node 1. and rest 1 on node 2.

For some reason failover happened.

All the applications moved to node 2.

here comes The problem, Every application is working fine unless one.
When i failback to node 1. it is working well

Both the nodes are possible owners for the application.

Any ideas please......

rookie here
Post #1466199
Posted Wednesday, June 26, 2013 3:40 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 8:55 AM
Points: 2,707, Visits: 2,318
Are you saying that you have SQL server database instances on a cluster and a particular application that uses them only works when it's database instance is running on one of the nodes of the cluster but not the other?

Or are you saying that one of the databse instances only works on one node and not the other?

When the database instance fails over to the other node does it come up successfully? Are you able to connect to the database via management studio when it is on the other node? Are you using static ports or dynamic? Is the browser running on both nodes? Is the Windows firewall blocking the port on the other node?

Sorry, a lot of questions but it will help to understand what is happening.

If it is applications running on the cluster rather than database instances, you may have to contact the vendor for support.
Post #1467891
Posted Thursday, June 27, 2013 7:37 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 10:12 AM
Points: 110, Visits: 501
It is perfectly coming UP when getting failed over.

The application is the one couldnot connect to the databases when failed over to the another node.

We are using Static Ports

I am not sure whether Browser working or not. (Dont know how to check that. can you please let me know so that i can check that., it could be a possibility)

Windows firewall is not blocking anything

I am able to connect with Management studio when DB gets FO

Rookie
Post #1468149
Posted Monday, July 1, 2013 5:32 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, May 22, 2014 7:04 AM
Points: 1,688, Visits: 8,766
Here are couple of common ways to access the SQL Server Browser service.

•Through Windows Services MMC. Access Windows services through the control panel or enter services.msc in the run box.
•Through a command prompt
•Through SQL Server Configuration Manager (SQL Server 2005/2008)
•Through Surface Area configuration (SAC, SQL Server 2005 only)
Post #1469242
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse