Far SQL2000 Server - Replication fails/Administration works

[Di0genes]

Windows NT Server 4.00.1381 or Windows 2000 Server SP3
MS SQL Server Standard 2000 (SP3)

What could be the reason for the following behavior:

We use 4 SQL servers in 4 different locations. Each of them could be administered by using the Enterprise Manager. I'm able to create tables or databases or anything else.
But if I trye to create a merge replication, the merge agent fails.

Error details:
"Das Schemaskript '\\Server1\d$\sql7\ReplData\unc\Relp_Ger2BG\20060123000505\table_1.sch' konnte nicht an den Abonnenten weitergegeben werden.
(Quelle: Mergereplikationsprovider (Agent); Fehlernummer: -2147201001)"

shold be the same like:
"The schema script ... could not be propagated to the subscriber."

If I try to replicate to a lokal copy of the far database - the replication works fine. Also if the "far" Server is in the same network like the publisher. So I assume that there is a problem in network communication. But why I can access an administrate the far servers?

-What is your Assumption?
-Whitch ports on tcp/ip I have to get checked by our network-team?

thanks and regards
Daniel

 

[mrdenny]

You will need to have port 1433 open between all the servers. You will also need all the UNC ports open (137-139, etc) from the subscribers to the folder that the snapshot is located in.

All the other server's will need to be running as a domain account which has admin rights to the server which is hosting the snapshot (server1 in your case).

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com