Post reply

SQL Server Merge - Pull replication error

  • October 1, 2013 at 4:41 am

    #298426

    I have a configuration problem to create a Merge/Pull replication between two databases SQLServer 2012.

    The machine Publisher is a Windows Server 2008 R2 not in windows domain, this Server is also the Distributor. The machine Subscriber is a Windows 8 not in windows domain.

    I have made the following settings: in the Published Server i created the distributor's folder, "repldata" and I also shared it and suser "everyone full control". The path's folder is \servername\repldata

    see image:

    I created Publisher, see image:

    I created Subscriber see image:

    I have done some settings in Distributor, Publisher and Subscriber but I don't get results, I always have access error.

    see image:

    -----------------------------------------------------------------------------------

    Error messages:

    The schema script 'BOOKING_2.sch' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)

    The process could not read file '\omemacchina\repldata\uncomemacchina$MSSQLSER VER2012_nomereplica\20130930125944\BOOKING_2.sch' due to OS error 5. (Source: MSSQL_REPL, Error number: MSSQL_REPL0)

    Access Denied.

    (Source: MSSQL_REPL, Error number: MSSQL_REPL5)

    -----------------------------------------------------------------------------------

    Can you tell me where is the problem? I have to do this replication but it looks like to be not possible

    Thanks in advance

    Alessandro

  • October 1, 2013 at 4:55 am

    #1654836

    Greatest forum post i've ever seen!

    Have a read here, could be something to do with the fact your servers aren't in any sort of domain. http://social.msdn.microsoft.com/Forums/sqlserver/en-US/380a0c1b-8a12-4d49-ad9b-485e080a0759/replication-monitor-showing-error-due-to-os-error-5-while-subscription-updation

  • October 3, 2013 at 2:45 am

    #1655445

    Hi Michael

    thanks for your reply now I'm trying to configure replication across interner.

  • October 8, 2013 at 4:48 am

    #1656671

    Hello

    I yet problems with web synchronization for the Merge Replication. I repeated every step described here: Web Synchronization for Merge Replication

    but I have always the same error:

    Security Error

    ....Unable to connect to the URL 'https://web3/SQLReplication/replisapi.dll' during Web synchronization Ensure that the URL <c/> login credentials to the Internet and the proxy server settings are correct and that the Web server is reachable., 00:00:02,0,0,,, 0.....

    From subscriber's InternertExplorer I try the url: https://web3/SQLReplication/replisapi.dll?diag and it works.

    I also have repeated this step http://technet.microsoft.com/en-us/library/ms152511.aspx but nothing result.

    Can anyone help me?

  • October 8, 2013 at 3:21 pm

    #1656927

    I hope you already checked http://www.sqlservercentral.com/Forums/Topic1102363-291-1.aspx#bm1115040

    Please ensure you have Automatic configuration turned off and proxy server disabled in Internet Explorer. Internet Explorer -> Tools -> Internet Options -> Connections -> LAN settings, uncheck 'Automatically detect settings', 'Use automatic configuration script', and 'Use a proxy server for your LAN'.

  • October 10, 2013 at 5:01 am

    #1657448

    Thanks MANU-J

    I checked my Internet Explorer and it is corrects, so I have always the problem, any idea? I'm desperate.... :crying:

Viewing 6 posts - 1 through 5 (of 5 total)

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