Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Replication Monitor

Author  Topic 

dolphin123
Yak Posting Veteran

84 Posts

Posted - 2012-12-21 : 15:58:26
Hi,

I set up snapshot replication. I am looking at replication monitor.

[img]
http://screencast.com/t/OX0BCt6OkJYC
[/img]

it says "Running" under the status but down in details it says "No replicated transactions are available.". I checked few tables and it seems that it has been loaded.

So why does it say it is running?

Regards,
D

prett
Posting Yak Master

212 Posts

Posted - 2012-12-24 : 01:01:39
I found the solution on many forums, here are all the steps:

1. Delete the whole replication including, first delete the subscriber then delete the publisher and then the distributer (make sure u delete the distributer by running select * from sysdatabases and u don’t want to see the distribution database (to delete the distributer make the database offline and then delete)

2. Create a login (Ex: replication_admin) with sysadmin privileges in publisher, subscriber and in distribution database and make the that login ad dbo for publisher and subscriber databases

3. Share the snapshot folder (Ex: \\servername\sharedname\) and gave enough permissions to sql service logins and the login under which u want r going to setup replication

4. Create the distributor, gave the snapshot shared folder while configuring the distributer, run the log reader agent and snapshot agents under sql service logins

5. Create the publisher and gave the replication_admin login for CONNECT TO DISTRIBUTER option

6. Check the replication monitor for any issues

7. Configure the subscriber and gave the sql service account login for CONNECT TO PUBLISHER option (if u r using pull subscription)

8. My publisher and subscriber servers runs under the same sql service account permissions (login and password is same for both)

Hope the solution will help you to resolve the issue!!
Go to Top of Page

xingchent
Starting Member

3 Posts

Posted - 2012-12-27 : 04:01:38
I recently came across your article and have been reading along. I want to express my admiration of your writing skill and ability to make readers read from the beginning to the end. I would like to read newer posts and to share my thoughts with you.
[url=http://www.louboutinshoesclub.com]Christian Louboutin Shoes[/url]
[url=http://www.louboutinshoesclub.com/christian-louboutin-tall-boots-c-490.html]Christian Louboutin Tall Boots[/url]
[url=http://www.karenmillenstyle.com]Karen Millen Outlet[/url]
[url=http://www.monclervestes.com/abercrombie-fitch-femme-c-9.html]Abercrombie Fitch Femme[/url]
[url=http://www.monclervestes.com/doudoune-woolrich-femme-c-12.html]Doudoune Woolrich Femme[/url]

xingchent xingchent
Go to Top of Page
   

- Advertisement -