Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Replication Error Expand / Collapse
Author
Message
Posted Monday, March 10, 2008 4:11 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, November 01, 2009 7:14 AM
Points: 19, Visits: 34
This is making me nuts! Here's an error I get when trying to synchronize that I can't seem to get around:
Replication-Replication Distribution Subsystem: agent LAPTOP\SQL05-AdventureWorks-demo-SNAPE\SQLEXPRESS-41 failed.
The process could not read file '\\Replicationdata\unc\LAPTOP$SQL05_ADVENTUREWORKS_DEMO\20080310133707\Contact_2.pre' due to OS error 53.
03/10/2008 14:56:18,spid55,Unknown,Error: 14151 Severity: 18 State: 1.

I'm trying to do a pull subscription from SQL Server Express with SQL Server Developer as the publisher.

I have no trouble opening the snapshot files on the publisher using Windows Explorer on the subscriber machine. I just can't do through Replication.

Any help would be appreciated.

Steve Hughes
Post #467016
Posted Tuesday, March 11, 2008 8:56 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 05, 2013 4:43 PM
Points: 1,473, Visits: 1,314
Did you have any chance to read the following article?
http://www.derkeiler.com/Newsgroups/microsoft.public.sqlserver.security/2004-03/0227.html
Post #467878
Posted Wednesday, March 12, 2008 11:07 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, October 29, 2013 8:36 AM
Points: 472, Visits: 853
Your Distribution Agent needs to be able to "READ" the file share where your storing the snapshot otherwise your going to get an error. The windows account your using as the Distribution Agent should be the only one that can READ. Your Snapshot Agent needs to be able to "WRITE" to the file share where your storing the snapshot otherwise your going to get an error.

http://technet.microsoft.com/en-us/library/ms151151.aspx
Post #468279
Posted Wednesday, March 12, 2008 2:28 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 03, 2013 4:44 PM
Points: 1,336, Visits: 595
Verify permission of user under which agent is running.

--www.sqlvillage.com
Post #468387
Posted Thursday, March 13, 2008 10:06 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, November 01, 2009 7:14 AM
Points: 19, Visits: 34
I did read it and when checking Sharing under Properties everything is opened up wide. Full Control for Everyone. I'm beginning to think it isn't a Permission issue, but a real "read error"
Post #468867
Posted Thursday, March 13, 2008 10:15 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, October 29, 2013 8:36 AM
Points: 472, Visits: 853
Are you using a "Domain User" acount as the Agent for access to the share? Verify your NTFS permissions allow access too. You could change the snapshot location to a different drive temp to see if that changes anything as a troubleshooting step.
Post #468875
Posted Thursday, October 16, 2008 9:40 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, February 21, 2014 8:23 AM
Points: 34, Visits: 502
Hello All,
I getting the same error.
"Error: 14151, Severity: 18, State: 1."
with
" TCPIP socket error has occured (10054): An existing connection was forcibly closed by the remote host. SQLSTATE: 08S01, SQLCODE: 10054"

Replication has been setup between SQL Server 2005 and DB2 tables on Mainframe.

This happens every time when the data gets replicated between the publisher and the subscriber.

Any thoughts??

Thanks
Prakash
Post #587090
Posted Tuesday, August 21, 2012 1:02 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, November 08, 2013 5:46 AM
Points: 5, Visits: 26
I know this is very late reply, but I hope it helps somebody.
The solution is to have same user (not domain user) created on both server boxes with the same password.
Make sure this user have access to the snapshot folders.
Then use windows authentication all along while setting up the replication.
Read this article for more details:
http://msdn.microsoft.com/en-us/library/ms151227.aspx

Post #1348050
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse