Click here to Skip to main content
16,016,925 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Could anyone please give me each step to setup sql server 2008 replication over internet or vpn.
Thank you a million.
Posted
Updated 18-Oct-13 16:08pm
v2

1 solution

You should have searched in CP prior to posting this question:
SQL server 2008 replication Step by Step Guidance!!!![^]
 
Share this answer
 
Comments
(pmac) 26-Sep-13 21:50pm    
When I try to replicate between two database in difference PC I got the error below:

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: 192.168.0.145]

both pc intalled sql server 2008.
Pradeep Shukla 26-Sep-13 22:22pm    
I hope you have sysadmin role if that is true try any of these:
1- Right click SSMS and run as Admin.
or
2- Turn off UAC:
http://windows.microsoft.com/en-us/windows-vista/turn-user-account-control-on-or-off
(pmac) 18-Oct-13 22:07pm    
I read this documents http://technet.microsoft.com/en-us/library/bb680505.aspx
and I do not understand the step number 6.

6. On the Distribution Agent Security page, click … and enter the security account settings used for Connection to Distributor and Connection to Subscriber.

What security account settings should I enter?
(pmac) 26-Sep-13 22:41pm    
Yes I have sysadmin role and my UAC is already "Never notify".
Add:
1. the error message above I get from Publisher PC > Sql server logs.
and on Subscriber PC I didn't see any error message.
2. my both PC use windows 7 and installed sql server management 2008.
both PC just in the same network, not join any domain.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900