Management point and server locator point site systems can use a SQL Server site database replica to access site information instead of connecting to the site database server itself. You can configure the management point and server locator point site systems to access a SQL Server site database replica from within the Configuration Manager console using the following procedures.

To configure a management point site system computer to access a SQL Server site database server replica

  1. In the Configuration Manager console of the primary site server, navigate to System Center Configuration Manager / Site Database / Site Management / <site code> - <site name> / Site Settings / Site Systems / <site system name>.

  2. In the results pane, right click ConfigMgr management point and click Properties.

  3. Select Use a database replica.

  4. In SQL Server name:, enter the SQL Server database computer hosting the SQL Server site database replica.

  5. In Database name:, enter the name of the replicated site database.

  6. Click OK to save changes and close the ConfigMgr management point properties dialog box.

To configure a server locator point site system computer to access a SQL Server site database server replica

  1. In the Configuration Manager console of the primary site server, navigate to System Center Configuration Manager / Site Database / Site Management / <site code> - <site name> / Site Settings / Site Systems / <site system name>.

  2. In the results pane, right click ConfigMgr server locator point and click Properties.

  3. Select Use a database replica.

  4. In SQL Server name:, enter the SQL Server database computer hosting the SQL Server site database replica.

  5. In Database name:, enter the name of the replicated site database.

  6. Click OK to save changes and close the ConfigMgr server locator point properties dialog box.

See Also