Replication Agent schedule
By default, Active Roles schedules the Replication Agents to run at the Publisher as follows:
-
The Snapshot Agent starts every day at 00:00.
-
The Merge Agents start automatically when SQL Server Agent starts, and runs continuously.
To verify the Snapshot Agent schedule
-
Open SQL Server Management Studio.
- In Object Explorer, connect to the instance of the SQL Server Database Engine that holds the Publisher role, and then expand that instance.
- Right-click the Replication folder, and click Launch Replication Monitor.
- In the left pane of the Replication Monitor window, expand your Publisher SQL Server, and click AelitaReplica.
-
In the right pane of the Replication Monitor window, on the Warnings and Agents tab, right-click the Snapshot Agent in the Agents and jobs related to this publication list, and click Properties.
- In the left pane of the Job Properties window, click Schedules.
- Review the Replication Agent schedule settings in the right pane of the Job Properties window.
- To view the Replication Agent schedule settings in detail, click Edit.
To verify the Merge Agent schedule
-
Open SQL Server Management Studio.
- In Object Explorer, connect to the instance of the SQL Server Database Engine that holds the Publisher role, and then expand that instance.
- Right-click the Replication folder, and click Launch Replication Monitor.
- In the left pane of the Replication Monitor window, expand your Publisher SQL Server, and click AelitaReplica.
-
In the right pane of the Replication Monitor window, on the All Subscriptions tab, right-click the subscription whose Merge Agent you want to examine, and click View Details.
-
In the Subscription window, on the Action menu, click Merge Agent Job Properties.
- In the left pane of the Job Properties window, click Schedules.
- Review the Replication Agent schedule settings in the right pane of the Job Properties window.
- To view the Replication Agent schedule settings in detail, click Edit.
Identifying replication-related problems
To identify replication-related problems, you can use the Active Roles Console connected to the Publisher Administration Service. If there are any replication failures, a red triangle is displayed on the Server Configuration and Configuration Databases containers in the Console tree. In the Details pane, the same icon is used to highlight the database affected by a replication failure.
If you have encountered a replication failure, you should ensure that the SQL Server Agent service is started on the computer that is running the Publisher SQL Server, and then use SQL Server Management Studio to get more information on that failure.
To ensure that the SQL Server Agent service is started on the computer that is running the Publisher SQL Server
-
In Object Explorer, connect to the instance of the SQL Server Database Engine that holds the Publisher role, and then expand that instance.
-
Right-click the Replication folder, and click Launch Replication Monitor.
-
In the left pane of the Replication Monitor window, expand your Publisher SQL Server, and click AelitaReplica.
-
In the right pane of the Replication Monitor window, on the Warnings and Agents tab, under Agents and jobs related to this publication, look for the icon. This icon indicates a Snapshot Agent error:
-
Right-click the agent that has encountered an error and then click View Details.
-
In the Snapshot Agent window, read the error description under Error details or message of the selected session.
-
In the right pane of the Replication Monitor window, on the All Subscriptions tab, in the list of subscriptions, look for the icon. This icon indicates a Merge Agent error:
-
On the All Subscriptions tab, right-click the subscription that has encountered an error and then click View Details.
-
In the Subscription window, view the error description under Last message of the selected session.
For more information on typical errors and how to resolve them, see the Troubleshooting replication failures.
Viewing database connection settings
The most common reasons for replication problems are access failures that Replication Agents encounter when attempting to connect to the Publisher or Subscriber SQL Server. The security credentials of the Replication Agents depend on the authentication mode of the Administration Service. To determine which authentication mode is actually used: Windows authentication or SQL Server authentication, view the Administration Service database connection settings.
To view connection settings in the Active Roles Console:
-
In the Console tree, select Configuration > Server Configuration > Administration Services.
-
In the details pane, right-click the Administration Service you want to view, and click Properties.
-
In the Properties dialog, go to the Configuration Database tab.
The Configuration Database tab displays the following information:
-
SQL Server: Identifies the SQL Server instance that is used by the Administration Service.
-
Database: The name of the Administration Service database.
-
Use Windows authentication: When this is selected, it indicates that the Administration Service uses Windows authentication mode when connecting to SQL Server.
-
Use SQL Server authentication: When this is selected, it indicates that the Administration Service uses SQL Server authentication mode when connecting to SQL Server.
-
Login name: The name of the SQL Server login that the Administration Service uses to access SQL Server. This only applies to the Use SQL Server authentication option.
Modifying database connection settings
You might have to modify Administration Service database connection settings if the login of the Administration Service for SQL Server authentication is no longer valid, or has the password changed. If you change the login, you also need to change it for Replication Agents, as described in Modifying Replication Agent credentials.
You can modify connection settings by using Active Roles Configuration Center.
To modify the connection settings
-
Start Configuration Center on the computer running the Administration Service, or connect Configuration Center to that computer.
You can start Configuration Center by selecting Active Roles 8.1.2 Configuration Center on the Apps page or Start menu, depending upon the version of your Windows operating system. For more information, see Running Configuration Center.
-
In the Configuration Center main window on the Dashboard page, in the Administration Service area, click Manage Settings.
-
On the Administration Service page that opens, in the Active Roles database area, click Change.
-
To view or change the login or password of the Administration Service for SQL Server authentication, use the Change Active Roles Database wizard that appears: Type the appropriate login name and password in the fields under the SQL Server authentication option on the Connection to Database page.