When checkng the last action message for the subsriber server the following message is displayed:
Connecting to subscriber database name
The subscriber has been in this status for over 24 hours
Upon checking replication monitor witin SQL management studio an error is shown as below:
Logon is from an unstrusted domain and cannot be used with Windows Authentication
CAUSE 1:
The service account specified for the subscriber database does not have the proper permissions
CAUSE 2:
The SQL server is unable to contact any domain controllers for authenticaiton
CAUSE 3:
The SQL Server Agent service is running with an account that does not have the proper permissions
RESOLUTION 1:
Check the required SQL permissions from the Quick Start guide pages 17 to 20
RESOLUTION 2:
Confirm that the SQL server is able to connect to the domain controller. Confirm that the account being used can access the database through SQL management studio.
RESOLUTION 3:
Check the required SQL permisisons from the Quick Start guide pages 17 to 20
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center