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
 SQL Server 2012 Forums
 Replication (2012)
 SQL Server Merge - Pull replication error
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

alessandros
Starting Member

3 Posts

Posted - 10/01/2013 :  06:54:28  Show Profile  Reply with Quote
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

Norway
3271 Posts

Posted - 10/01/2013 :  09:23:54  Show Profile  Reply with Quote
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
Go to Top of Page

alessandros
Starting Member

3 Posts

Posted - 10/03/2013 :  04:41:47  Show Profile  Reply with Quote
Thanks Lumbago
my problem was just in pass-through autentication, so I'm configuring replication web.
Go to Top of Page

alessandros
Starting Member

3 Posts

Posted - 10/08/2013 :  06:49:29  Show Profile  Reply with Quote
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?
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.06 seconds. Powered By: Snitz Forums 2000