Verify that the SQL Server Agent service is started on the Publisher SQL Server:
- With SQL Server Management Studio, connect to the Publisher SQL Server.
- In the console tree, right-click SQL Server Agent, and then click Start.
If the Start command is unavailable, the SQL Server Agent service is already started.
Ensure that the Merge Agents are started on the Publisher SQL Server:
- With SQL Server Management Studio, connect to the Publisher SQL Server.
- In the console tree, right-click Replication, and click Launch Replication Monitor.
- In Replication Monitor, in the left pane, browse the My Publishers branch to select the AelitaReplica publication.
- In Replication Monitor, in the right pane, right-click a subscription and click Start Synchronizing. Perform this step for each subscription of the AelitaReplica publication.
If the Start Synchronizing command is unavailable, the agent is already started.
Verify that the replication agent schedule is correct. The Merge Agents must be configured to run continuously at the Publisher. The Snapshot Agent must be configured to start daily at 12:00 a.m. at the Publisher. For details, see Replication Agent schedule.
Symptoms
Replication fails with one of the following errors on the Snapshot Agent or Merge Agent (see Monitoring replication):
- The process could not connect to Publisher ‘<Server_name>’. Login failed for user ‘<User_name>’.
- The process could not connect to Subscriber ‘<Server_name>’. Login failed for user ‘<User_name>’.
By using SQL Server Enterprise Manager or SQL Server Management Studio, verify that the Replication Agent credentials are set properly. The following conditions must be met:
Table 113: Conditions for Replication Agent credentials
Publisher
|
Windows Authentication |
Impersonate the SQL Server Agent account on the computer running the Publisher SQL Server (trusted connection) |
SQL Server Authentication |
SQL Server login and password that the Publisher Administration Service uses to connect to its SQL Server |
Subscriber
|
Windows Authentication |
Impersonate the SQL Server Agent account on the computer running the Publisher SQL Server (trusted connection) |
SQL Server Authentication |
SQL Server login and password that the Subscriber Administration Service uses to connect to its SQL Server |
For information on how to view or modify the credentials that the Snapshot Agent and Merge Agents use to connect to the Publisher and Subscribers, see Modifying Replication Agent credentials.
Symptoms
When promoting SQL Server to Publisher, or adding it as a Subscriber to the existing Publisher, the operation fails with the following error: “An alias cannot be used for replication. Use the name of the SQL Server instance.”