Post reply

Replication Error

  • March 10, 2008 at 4:11 pm

    #204221

    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

  • March 11, 2008 at 8:56 pm

    #788371

    Did you have any chance to read the following article?

    http://www.derkeiler.com/Newsgroups/microsoft.public.sqlserver.security/2004-03/0227.html

  • March 12, 2008 at 11:07 am

    #788703

    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

  • March 12, 2008 at 2:28 pm

    #788792

    Verify permission of user under which agent is running.

    [font="Verdana"]--www.sqlvillage.com[/size][/font]

  • March 13, 2008 at 10:06 am

    #789183

    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"

  • March 13, 2008 at 10:15 am

    #789190

    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.

  • October 16, 2008 at 9:40 am

    #885928

    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

    Prakash B

  • August 21, 2012 at 1:02 pm

    #1528337

    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

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply