SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Replication Monitor
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

dolphin123
Yak Posting Veteran

USA
54 Posts

Posted - 12/21/2012 :  15:58:26  Show Profile  Reply with Quote
Hi,

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

http://screencast.com/t/OX0BCt6OkJYC br / " border="0">

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

USA
181 Posts

Posted - 12/24/2012 :  01:01:39  Show Profile  Visit prett's Homepage  Reply with Quote
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 - 12/27/2012 :  04:01:38  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000