SQL Server Merge - Pull replication error

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

SQL Server 2012 Forums

Replication (2012)

SQL Server Merge - Pull replication error

Author

Topic

alessandros
Starting Member

3 Posts

Posted - 2013-10-01 : 06:54:28

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: www.alessandrosenesi.com/download/distributor.jpg

I created Publisher, see image: www.alessandrosenesi.com/download/Publisher.jpg

I created Subscriber see image: www.alessandrosenesi.com/download/subscriber.jpg

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

see image: www.alessandrosenesi.com/download/log.jpg

-----------------------------------------------------------------------------------
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 '\\nomemacchina\repldata\unc\nomemacchina$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

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2013-10-01 : 09:23:54

Replication between servers that are not a part of a domain is not easy. You'll probably have to use SSL / certificates. Have a look at this link (unfortunately I don't have any first hand experience):

http://technet.microsoft.com/en-us/library/ms151763.aspx

- Lumbago
My blog-> http://thefirstsql.com

alessandros
Starting Member

3 Posts

Posted - 2013-10-03 : 04:41:47

Thanks Lumbago
my problem was just in pass-through autentication, so I'm configuring replication web.

alessandros
Starting Member

3 Posts

Posted - 2013-10-08 : 06:49:29

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?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources