[Webinar] Streamline your web hosting managementRegister Today

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 41
  • Last Modified:

SQL 2012 replication monitoring showing that it is running, but actually replication not happening


We are currently having an issue with SQL replication, we have source database replication has been setup to a another database.
It is transaction replication, it was running with a AD account, recently the user has left the organization, and replication has been stopped.

Later on we fix the user issue by adding a service account on it, it has started the process and after few time the replication has been stopped. but Spotlight and SQL replication monitor show the replication happening.

But actual data table does not sync with new data from the source.

is anyone had the problem like this or any help to resolve this?
ken hanse
ken hanse
  • 2
2 Solutions
Marten RuneSQL Expert/Infrastructure ArchitectCommented:
Does the serviceaccount have proper rights in the databases and instances?
Sometimes security settings are very picky, yet don't fail any kind of validation checks. I
Read this https://msdn.microsoft.com/en-us/library/ms151868(v=sql.105).aspx
And found it quite helpful

Try following through the list of permissions very meticulously. I think it could be an issue with the account that the log reader agent was running under.
ken hanseAuthor Commented:
thanks for the post, all the tips were helped.
Valid recommendations and author said he got the solutions from the comments

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now