asked
Snap replication is not replicating
I did Snapshot replication in sql server 2012 but the data is not being replicated. when i checked in the replication monitor i found sanp shot agent status is stopped and when i tried to restart it again it is going back to its own position with out starting The error is:Error messages: Message: Login failed for user 'NT Service\SQLAgent$SQLDIST'. Stack: at Microsoft.SqlServer.Replication.ServerConnectionEmulator.Connect() at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.EstablishPublisherConnection() at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.GenerateSnapshot() at Microsoft.SqlServer.Replication.SnapshotGenerationAgent.InternalRun() at Microsoft.SqlServer.Replication.AgentCore.Run() (Source: MSSQLServer, Error number: 18456) Get help: http://help/18456
You need to make sure that the user credentials between the servers (publisher/distributor/subscriber) is set and that they have access to each other. Here is an article that may be of benefit:
https://blogs.msdn.microsoft.com/sqlserverfaq/2009/12/21/error-messages-and-the-solutions-related-to-distributor_admin-login/
18 People are following this question.
