Let me first tell you my current environment in which there is one windows cluster on which there is sql cluster with two nodes, i.e, A and B in it. Of which, one A is active and B is passive. So, what I want is to use my passive node, i.e, B for some other application's database and make it work like active node for this application and A which will act as passive in this case. Using this I can utilize my one server which is free at a time.
The point is that can we do that?