skpani (8/22/2013)
I have configured DB Mirroring with automatic fail over.My users are connected to Server_A .My Partner is Server_B and witness is Server_C.As we know that whenever a fail over occurs Server_B will take the roll from Server_A and it becomes Online.But my point is how the users are redirected to Server_B.Is it the DBA who changes the connection string or the Application Developer or the Database Developer.How ? What happens behind the screen.Please explain this with details..
There should be no need to modify the connection string due to a failover from principal to mirror. If the connection string is setup to include both the principal and failover servers, the application itself will manage the switch as needed with no outside intervention required.
The only time the connection string would need to modified would be if the connection string contained only the server name for the principal server and no partner server was included and it was the first time a client was attempting to connect and the named server was unavailable.
Read more here:
http://msdn.microsoft.com/en-us/library/ms366348(v=SQL.100).aspx