Microsoft® SQL Server 2012 Unleashed

Client Setup and Configuration for Database Mirroring

Microsoft has enhanced the client connection capabilities to become mirroring-aware. In other words, a client application is now able to connect to either partner in a mirrored configuration. The client would, of course, be connecting only to the server instance that is the current principal. With the help of an extension to the client connection configuration file, all .NET applications can easily add both partners to their connection string information, and when a principal fails, they can automatically establish a connection to the new principal (in a mirrored configuration). Figure 41.27 shows the added connection string information that you provide in the configuration file (app.config ...