Set the SQL Server Distributor agent profile - Intergraph Smart 3D - Administration

Intergraph Smart 3D Project Management

3D Design and Visualization
Intergraph Smart 3D

You must configure the distributor on each server participating in replication. This must be done before you start replication. For information on configuring the distributor, see Configure the SQL Server Distributor agent. For more detailed information on the Microsoft SQL Server Management Studio, see your SQL Server documentation.

Repeat the procedure below for each registered server that participates in replication.

  1. In the Microsoft SQL Server Management Studio, right-click Replication in the Object Explorer window, and select Distributor Properties.

    The Distributor Properties dialog box appears.

  2. Select the General page, and click Profile Defaults in the Agent Profile section of the page.

  3. On the Agent Profiles dialog box, select the Distribution Agents page, and click New in the Agent Profiles section of the page.

  4. In the New Agent Profile dialog box, select Distribution Profile for OLEDB Streaming, and click OK.

  5. Set up the new agent profile as needed. For example: specify the name as "Sp3dProfile" and set an appropriate value (2601:2627:50000:20598:532) for the SkipErrors profile parameter. Click OK to accept the new profile settings.

    The Agent Profiles dialog box now shows the new profile in the Agent profiles list.

  6. Select the new profile and click Change Existing Agents.

    SQL Server updates all existing Distribution Agents to use the specified profile.

  7. Click OK to close the dialog box, and then click OK again to return to the Object Explorer window.