CCF settings for Database mirroring

  • Article

CCF services can take advantage of redirecting connections when a database mirroring failover occurs. You can install CCF 2009 SP1 on a SQL Server with database mirroring to ensure high-availability of the SQL Server instance. You must specify the initial principal server and database in the connection string and the failover partner server. In case of failure in the principal server, database mirroring enables CCF to quickly move over to the failover partner server.

While installing CCF Server to support database mirroring, ensure that you set the database server name to the principal database server name. For more information about installing CCF Database Server, see Installing CCF Database Server. You must than configure CCF to use the failover partner server, in case of a failure in the primary database server.

To configure CCF to use database mirroring:

  1. For each of the web services, open the web.config file the <Install Path>/Program files/Microsoft CCF 2009/Web Services/<web service name>. For example, for the web service Microsoft.Ccf.ConfigManagementDataService the folder path would be <Install Path>/Program files/Microsoft CCF 2009/Web Services/Microsoft.Ccf.ConfigManagementDataService.

  2. In the connection string node of the configuration file, update the connection string to include the failover partner server name.

  3. <connectionStrings>
  <add name="ConfigurationSqlServer" connectionString="Data Source=CCF_SQLServer;Initial Catalog=ConfigurationServerDB;Integrated Security=True;Failover Partner = CCF_MirrorServer" providerName="" />
</connectionStrings>

  4. Save the web.config file and close it.

  5. Repeat the procedure for all the web services in the folder <Install Path>/Program files/Microsoft CCF 2009/Web Services/.

  6. Restart IIS.