Configure each server for replication - Intergraph Smart 3D - Administration & Configuration - Hexagon PPM

Intergraph Smart 3D Global Workshare (SQL Server)

Language
English
Product
Intergraph Smart 3D
Subproduct
Global Workshare
Search by Category
Administration & Configuration
Smart 3D Version
13

All SQL Server servers that will take part in replication should be registered through the Microsoft SQL Server Management Studio. Detailed information on the Microsoft SQL Server Management Studio in your SQL Server documentation.

  1. In the Microsoft SQL Server Management Studio, expand Database Engine in the Registered Servers window.

  2. Right-click Local Server Groups, and select New Server Registration.

  3. On the New Server Registration dialog General tab, specify the name of the SQL server that will participate in replication.

  4. Click Save.

  • When you select an SQL Server in the Registered Servers window, check the Object Explorer window to make sure that the SQL Server Agent is running.

  • Make sure that the SQL Server Agent is running on all the database servers and that it is running using an account that has access to all the database servers. Do not use the local system account.

    1. Click Control Panel > Administrative Tools > Services.

    2. Right-click SQL Server Agent, and select Properties.

    3. On the General tab, select Automatic as the Startup type.

    4. On the Log On tab, select This Account, and type a user name and password for a user that has access to the other database servers.

  • You can use Start > All Programs > Microsoft SQL Server > Configuration Tools > SQL Server Configuration Manager to check the status of the SQL Server Agent. Refer to your SQL Server documentation.