SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Application fails on cluster failover


Application fails on cluster failover

Author
Message
rajborntodare
rajborntodare
SSC Veteran
SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)

Group: General Forum Members
Points: 293 Visits: 510
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 Hehe
DNA_DBA
DNA_DBA
Hall of Fame
Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)

Group: General Forum Members
Points: 3164 Visits: 2772
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.
rajborntodare
rajborntodare
SSC Veteran
SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)SSC Veteran (293 reputation)

Group: General Forum Members
Points: 293 Visits: 510
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 Hehe
MANU-J.
MANU-J.
Hall of Fame
Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)

Group: General Forum Members
Points: 3028 Visits: 8766
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)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search