Solved

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

Posted on 2016-09-07
4
24 Views
Last Modified: 2016-09-30
Hi,

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?
0
Comment
Question by:ken hanse
  • 2
4 Comments
 
LVL 20

Assisted Solution

by:Marten Rune
Marten Rune earned 200 total points (awarded by participants)
ID: 41790076
Does the serviceaccount have proper rights in the databases and instances?
0
 
LVL 17

Accepted Solution

by:
xtermie earned 300 total points (awarded by participants)
ID: 41790132
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.
0
 

Author Comment

by:ken hanse
ID: 41790592
thanks for the post, all the tips were helped.
0
 
LVL 17

Expert Comment

by:xtermie
ID: 41823160
Valid recommendations and author said he got the solutions from the comments
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
OfficeMate Freezes on login or does not load after login credentials are input.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now