I have three databases which i have configured mirror on sql server 2008 for all the databases.
Manual Failover with one principal and mirror. (Witness planning in the future)
Using Windows authentication (Since same login and pass, neither new endpoints are created and not certificate created)
This is working smoothly.
I have 7 .net applications which uses these three databases.
All the 7 applications uses the same three databases.
1)I need how to provide the connection strings for these applications to get connected.
2)In case if failover is applied on only one databes, then how does it work?
Because in some joins I have to connect two different databases and retrive the data.
What will be the syntax for the connection strings in this case.
What are the steps to be taken care to run the applications smoothly.?
Thanks for any inputs.